D.14. RDB$FUNCTION_ARGUMENTS

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

Column NameData TypeDescription

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 4 - by scalar array 5 - by reference with null

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 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)