SYSCAT.CONTROLDEP catalog view

Each row represents a dependency of a row permission or column mask on some other object.

Table 1. SYSCAT.CONTROLDEP Catalog View
Column Name Data Type Nullable Description
DSCHEMA VARCHAR (128)   Schema name of the row permission or column mask.
DNAME VARCHAR (128)   Unqualified name of the row permission or column mask.
DTYPE CHAR (1)   Type of the depending object.
  • y = Row Permission
  • 2 = Column Mask
BTYPE CHAR (1)   Type of object on which there is a dependency:
  • A = Table alias
  • C = Column
  • F = Routine
  • H = Hierarchy table
  • I = Index
  • L = Detached table
  • S = Materialized query table
  • T = Table (not typed)
  • U = Typed table
  • V = View (not typed)
  • W = Typed view
  • m = Module
  • s = Statistical Table
  • u = Module alias
  • v = Global variable
BSCHEMA VARCHAR (128)   Schema name of the object on which there is a dependency.
BMODULENAME VARCHAR (128) Y Unqualified name for the module of the object on which the control depends. The null value if not a module object.
BNAME VARCHAR (128)   Unqualified name of the object on which there is a dependency.
BMODULEID INTEGER Y Identifier for the module of the object on which the control depends.
BCOLNAME VARCHAR (128) Y If BTYPE = 'C', the column name on which there is a dependency; the null value otherwise.