SYSCAT.DATATYPEDEP catalog view

Each row represents a dependency of a user-defined data type on some other object.

Table 1. SYSCAT.DATATYPEDEP Catalog View
Column Name Data Type Nullable Description
TYPESCHEMA VARCHAR (128)   Schema name of the data type.
TYPEMODULENAME VARCHAR (128) Y Module name of the data type.
TYPENAME VARCHAR (128)   Unqualified name of the data type.
TYPEMODULEID INTEGER Y Identifier for the module of the data type.
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
  • 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 Module name of the object on which there is a dependency.
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 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 = 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges on the table or view that are required by the dependent data type; the null value otherwise.