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_CATALOG![]() |
BCATALOG![]() |
VARCHAR(128)Nullable Contains the null value if the relational database name was not specified. ![]() |
Name of the relational database that
contains the object.![]() |
| 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. |