The SYSROUTINEDEP view records the dependencies of routines. The following table describes the columns in the SYSROUTINEDEP view:
Column name | System Column Name | Data Type | Description |
---|---|---|---|
SPECIFIC_SCHEMA | SPECSCHEMA | VARCHAR(128) | Schema name of the routine instance. |
SPECIFIC_NAME | SPECNAME | VARCHAR(128) | Specific name of the routine instance. |
OBJECT_SCHEMA | BSCHEMA | VARCHAR(128) | Name of the SQL schema that contains the object. |
OBJECT_NAME | BNAME | VARCHAR(128) | Name of the object the routine is dependent on. |
OBJECT_TYPE | BTYPE | CHAR(24) | Indicates the object type of the object referenced
in the routine:
|
PARM_SIGNATURE | SIGNATURE | VARCHAR(10000)
Nullable |
This column identifies the routine signature.
Contains the null value if the object is not a routine. |
IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number of the object. |
NUMBER_OF_PARMS | NUMPARMS | SMALLINT
Nullable |
Identifies the number of parameters.
Contains the null value if the object is not a routine. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.