RDB$FUNCTION ARGUMENTS

Go Up to System Tables

RDB$FUNCTION_ARGUMENTS defines the attributes of a function argument.

Column name	Datatype	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		Datatype 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