DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.ROUTINEPARMS catalog view

Each row represents a parameter or the result of a routine defined in SYSCAT.ROUTINES.

Table 1. SYSCAT.ROUTINEPARMS Catalog View
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)  
  • B = Both input and output parameter
  • C = Result after casting
  • O = Output parameter
  • P = Input parameter
  • R = Result before casting
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)  
  • N = Paramater or result is not passed in the form of a locator
  • Y = Paramater or result is passed in the form of a locator
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:
  1. LENGTH and SCALE are set to 0 for sourced functions (functions defined with a reference to another function), because they inherit the length and scale of parameters from their source.