RDB$FUNCTION ARGUMENTS

From InterBase

Go Up to System Tables


RDB$FUNCTION_ARGUMENTS defines the attributes of a function argument.

Column name Data type Length Description

RDB$FUNCTION_NAME

CHAR

67

Unique name of the function with which the argument is associated; must correspond to a function name in RDB$FUNCTIONS

RDB$ARGUMENT_POSITION

SMALLINT

Position of the argument described in the RDB$FUNCTION_NAME column in relation to the other arguments

RDB$MECHANISM

SMALLINT

Specifies whether the argument is passed by value (value of 0) or by reference (value of 1)

RDB$FIELD_TYPE

SMALLINT

Data type of the argument being defined

Valid values are:

  • BLOB - 261
  • BLOB_ID - 45
  • BOOLEAN - 17
  • CHAR - 14
  • CSTRING - 40
  • D_FLOAT - 11
  • DOUBLE - 27
  • FLOAT - 10
  • INT64 - 16
  • INTEGER - 8
  • QUAD - 9
  • SMALLINT - 7
  • DATE - 12
    (dialect 3 DATE)
  • TIME - 13
  • TIMESTAMP - 35
  • VARCHAR - 37

RDB$FIELD_SCALE

SMALLINT

Scale factor for an argument that has an integer data type; the scale factor is the power of 10 by which the integer is multiplied

RDB$FIELD_LENGTH

SMALLINT

The length of the argument defined in this row

Valid column lengths are:

  • BLOB - 8
  • BOOLEAN - 2
  • D_FLOAT - 8
  • DATE - 4
  • DOUBLE - 8
  • FLOAT - 4
  • INT64 - 8
  • LONG - 4
  • QUAD - 8
  • SHORT - 2
  • TIME - 4
  • TIMESTAMP - 8

RDB$FIELD_SUB_TYPE

SMALLINT

If RDB$FIELD_TYPE is 7 (SMALLINT),8 (INTEGER), or 16 (INT64) the subtype can be:

  • 0 or NULL - RDB$FIELD_TYPE
  • 1 - NUMERIC
  • 2 - DECIMAL

RDB$CHARACTER_SET_ID

SMALLINT

Unique numeric identifier for a character set

RDB$FIELD_PRECISION SMALLINT The declared precision of the DECIMAL or NUMERIC function argument