SYSVARIABLEDEP

The SYSVARIABLEDEP table records the dependencies of variables.

The following table describes the columns in the SYSVARIABLEDEP table:

Table 1. 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: ALIAS The object is an alias. FUNCTION The object is a function. MATERIALIZED QUERY TABLE The object is a materialized query table. SCHEMA The object is a schema. SEQUENCE The object is a sequence. TABLE The object is a table. TYPE The object is a distinct type. VARIABLE The object is a variable. VIEW The object is a view.
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.