SYSVARIABLEDEP
The SYSVARIABLEDEP table records the dependencies of variables.
The following table describes the columns in the SYSVARIABLEDEP table:
Column name | System Column Name | Data Type | Description |
---|---|---|---|
VARIABLE_SCHEMA | VARSCHEMA | VARCHAR(128) | Schema name of the variable. |
VARIABLE_NAME | VARNAME | VARCHAR(128) | Name of the variable. |
OBJECT_SCHEMA | BSCHEMA | VARCHAR(128) | Name of the SQL schema that contains the object. |
OBJECT_NAME | BNAME | VARCHAR(128) | Name of the object the variable is dependent on. |
OBJECT_TYPE | BTYPE | CHAR(24) | Indicates the object type of the
object referenced in the variable:
|
IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number of the object. |
PARM_SIGNATURE | SIGNATURE | VARCHAR(10000) Nullable
|
This column identifies the routine
signature. Contains the null value if the object is not a routine. |