
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. |
