SYSCAT.VARIABLEDEP catalog view

Each row represents a dependency of a global variable on some other object. The global variable depends on the object of type BTYPE of name BNAME, so a change to the object affects the global variable.

Table 1. SYSCAT.VARIABLEDEP Catalog View
Column Name Data Type Nullable Description
VARSCHEMA VARCHAR (128)   Schema name of the global variable that has dependencies on another object.
VARMODULENAME VARCHAR (128) Y Unqualified name of the module to which the global variable belongs. The null value if not a module variable.
VARNAME VARCHAR (128)   Unqualified name of the global variable that has dependencies on another object.
VARMODULEID INTEGER Y Identifier for the module of the object that has dependencies on another object.
BTYPE CHAR (1)   Type of object on which there is a dependency. Possible values are:
  • A = Table alias
  • F = Routine
  • G = Global temporary table
  • H = Hierarchy table
  • I = Index
  • N = Nickname
  • O = Privilege dependency on all subtables or subviews in a table or view hierarchy
  • R = User-defined data type
  • S = Materialized query table
  • T = Table (not typed)
  • U = Typed table
  • V = View (not typed)
  • W = Typed view
  • m = Module
  • q = Sequence alias
  • u = Module alias
  • v = Global variable
  • * = Anchored to the row of a base table
BSCHEMA VARCHAR (128)   Schema name of the object on which there is a dependency.
BMODULENAME VARCHAR (128) Y Unqualified name of the module to which the object on which a dependency belongs. The null value if not a module object.
BNAME VARCHAR (128)   Unqualified name of the object on which there is a dependency. For routines (BTYPE = 'F'), this is the specific name.
BMODULEID INTEGER Y Identifier for the module of the object on which there is a dependency.
TABAUTH SMALLINT Y
The value for this column is encoded as a bitmap, the values of which can be found in <install path>/include/sql.h and are as follows:
  • 0x1 = Control Authority
  • 0x2 = Alter Privilege
  • 0x4 = Alter Privilege
  • 0x8 = Index Privilege
  • 0x10 = Insert Privilege
  • 0x20 = Select Privilege
  • 0x40 = Update Privilege
  • 0x80 = Reference Privilege
  • 0x2000 = Key Dependency
  • 0x4000 = Cascade Dependency
If BTYPE = 'O', 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges on the table or view that are required by the dependent global variable; the null value otherwise.