Each row represents a parameter or the result of a routine defined in SYSCAT.ROUTINES.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
ROUTINESCHEMA | VARCHAR (128) | Y | Schema name of the routine if ROUTINEMODULEID is null; otherwise schema name of the module to which the routine belongs. |
ROUTINEMODULENAME | VARCHAR(128) | Y | Unqualified name of the module to which the routine belongs. The null value if not a module routine. |
ROUTINENAME | VARCHAR (128) | Y | Unqualified name of the routine. |
ROUTINEMODULEID | INTEGER | Y | Identifier for the module to which the routine belongs. The null value if not a module routine. |
SPECIFICNAME | VARCHAR (128) | Y | Name of the routine instance (might be system-generated). |
PARMNAME | VARCHAR (128) | Y | Name of the parameter or result column, or the null value if no name exists. |
ROWTYPE | CHAR (1) |
|
|
ORDINAL | SMALLINT | If ROWTYPE = 'B', 'O', or 'P', numerical position of the parameter within the routine signature, starting with 1; if ROWTYPE = 'R' and the routine returns a table, numerical position of a named column in the result table, starting with 1; 0 otherwise. | |
TYPESCHEMA | VARCHAR (128) | Y | Schema name of the data type if TYPEMODULEID is null; otherwise schema name of the module to which the data type belongs. |
TYPEMODULENAME | VARCHAR(128) | Y | Unqualified name of the module to which the data type of the parameter or result belongs. The null value if not a module data type. |
TYPENAME | VARCHAR (128) | Y | Unqualified name of the data type. |
LOCATOR | CHAR (1) |
|
|
LENGTH1 | INTEGER | Length of the parameter or result; 0 if the parameter or result is a user-defined data type. | |
SCALE1 | SMALLINT | Scale if the parameter or result data type is DECIMAL; the number of digits of fractional seconds if the parameter or result data type is TIMESTAMP; 0 otherwise. | |
CODEPAGE | SMALLINT | Code page of this parameter or result; 0 denotes either not applicable, or a parameter or result for character data declared with the FOR BIT DATA attribute. | |
COLLATIONSCHEMA | VARCHAR (128) | Y | For string types, the schema name of the collation for the parameter; the null value otherwise. |
COLLATIONNAME | VARCHAR (128) | Y | For string types, the unqualified name of the collation for the parameter; the null value otherwise. |
CAST_FUNCSCHEMA | VARCHAR (128) | Y | Schema name of the function used to cast an argument or a result. Applies to sourced and external functions; the null value otherwise. |
CAST_FUNCSPECIFIC | VARCHAR (128) | Y | Unqualified name of the function used to cast an argument or a result. Applies to sourced and external functions; the null value otherwise. |
TARGET_TYPESCHEMA | VARCHAR (128) | Y | Schema name of the target type if the type of the parameter or result is REFERENCE. Null value if the type of the parameter or result is not REFERENCE. |
TARGET_TYPEMODULENAME | VARCHAR(128) | Y | Unqualified name of the module to which the target type belongs if the type of the parameter or result is REFERENCE. The null value if the type of the parameter or result is not REFERENCE or if the target type is not a module data type. |
TARGET_TYPENAME | VARCHAR (128) | Y | Unqualified name of the module to which the target type belongs if the type of the parameter or result is REFERENCE. The null value if the type of the parameter or result is not REFERENCE or if the target type is not a module data type. |
SCOPE_TABSCHEMA | VARCHAR (128) | Y | Schema name of the scope (target table) if the parameter type is REFERENCE; null value otherwise. |
SCOPE_TABNAME | VARCHAR (128) | Y | Unqualified name of the scope (target table) if the parameter type is REFERENCE; null value otherwise. |
TRANSFORMGRPNAME | VARCHAR (128) | Y | Name of the transform group for a structured type parameter or result. |
DEFAULT | CLOB (64K) | Y | Expression used to calculate the default value of the parameter. The null value if DEFAULT clause was not specified for the parameter. |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|