Column name
|
Data type
|
Description
|
ROUTINE_SYSID
|
INTEGER
|
System identifier of the function or procedure. |
MODULE_SYSID
|
INTEGER
|
System identifier of the module to which the routine belongs. |
ROUTINE_TYPE
|
CHAR(20)
|
One of:
"PROCEDURE"
"FUNCTION". |
SQL_DATA_ACCESS
|
CHAR(20)
|
One of:
"NO SQL"
"CONTAINS SQL"
"READS SQL DATA"
"MODIFIES SQL DATA". |
ROUTINE_OFFSET
|
INTEGER
|
Offset for routine within module definition. This value is zero if the routine ins not defined in a module. |
ROUTINE_LENGTH
|
INTEGER
|
Length of routine definition |
TOTAL_PARAMS
|
INTEGER
|
The total number of routine parameters. |
RESULT_PARAMS
|
INTEGER
|
The number of result parameters. |
INPUT_PARAMS
|
INTEGER
|
The number of input parameters. |
OUTPUT_PARAMS
|
INTEGER
|
The number of output parameters. |
ROUTINE_DEFINITION
|
VARCHAR(2000)
|
Routine definition. If the length of the routine definition exceeds 2000 characters this value is null. |
SQL_PATH
|
VARCHAR(2000)
|
The search path for the routine. |
IS_DETERMINISTIC
|
CHAR(3)
|
One of:
'"NO" = The routine is not deterministic. i.e. invoking the routine with the same input values is not guaranteed to return the same result
"YES" = The routine is deterministic, i.e. when invoked with same input values it will always return the same result. |
ROUTINE_BODY
|
CHAR(20)
|
One of:
"SQL" = The routine is a SQL routine
"EXTERNAL" = The routine is external |
EXTERNAL_NAME
|
VARCHAR(128)
|
The name of the program that implements the routine if it is an external routine otherwise null. |
EXTERNAL_LANGUAGE
|
CHAR(20)
|
The language for the routine if it is external otherwise null. |
PARAMETER_STYLE
|
CHAR(20)
|
The parameter passing style for the routine if it is an external routine, otherwise null. |
SCHEMA_LEVEL_ROU
|
CHAR(3)
|
One of:
"NO" = The routine is defined within a module
"YES" = The routine is defined in a module. |
MX_DYN_RESULT_SETS
|
INTEGER
|
The maximal number of result sets that the routine may return. |
