Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$FUNCTION_ARGUMENTS
Firebird Firebird Prev: RDB$FUNCTIONSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$GENERATORS

RDB$FUNCTION_ARGUMENTS

RDB$FUNCTION_ARGUMENTS stores the parameters of external functions and their attributes.

Column Name Data Type Description
RDB$FUNCTION_NAME CHAR(31) The unique name (declared identifier) of the external function
RDB$ARGUMENT_POSITION SMALLINT The position of the argument in the list of arguments
RDB$MECHANISM SMALLINT Flag: how this argument is passed:
  • 0 = by value
  • 1 = by reference
  • 2 = by descriptor
  • 3 = by BLOB descriptor
RDB$FIELD_TYPE SMALLINT Data type code defined for the column:
7 = SMALLINT
8 = INTEGER
12 = DATE
13 = TIME
14 = CHAR
16 = BIGINT
27 = DOUBLE PRECISION
35 = TIMESTAMP
37 = VARCHAR
261 = BLOB
40 = CSTRING (null-terminated text)
45 = BLOB_ID
261 = BLOB
RDB$FIELD_SCALE SMALLINT The scale of an integer or a fixed-point argument. It is an exponent of 10
RDB$FIELD_LENGTH SMALLINT Argument length in bytes:
SMALLINT = 2
INTEGER = 4
DATE = 4
TIME = 4
BIGINT = 8
DOUBLE PRECISION = 8
TIMESTAMP = 8
BLOB_ID = 8
RDB$FIELD_SUB_TYPE SMALLINT Stores the BLOB subtype for an argument of a BLOB data type
RDB$CHARACTER_SET_ID SMALLINT The identifier of the character set for a character argument
RDB$FIELD_PRECISION SMALLINT The number of digits of precision available for the data type of the argument
RDB$CHARACTER_LENGTH SMALLINT The length of a CHAR or VARCHAR argument in characters (not in bytes)

Prev: RDB$FUNCTIONSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$GENERATORS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$FUNCTION_ARGUMENTS