SYSCAT.ROUTINEDEP catalog view

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

Table 1. SYSCAT.ROUTINEDEP Catalog View
Column Name Data Type Nullable Description
ROUTINESCHEMA VARCHAR (128)   Schema name of the routine that has dependencies on another object.
ROUTINEMODULENAME VARCHAR (128) Y Unqualified name of the module.
SPECIFICNAME VARCHAR (128)   Specific name of the routine that has dependencies on another object.
ROUTINEMODULEID 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
  • B = Trigger
  • C = Column
  • F = Routine
  • G = Global temporary table
  • H = Hierachy table
  • I = Index
  • K = Package
  • L = Detached table
  • N = Nickname
  • O = Privilege dependency on all subtables or subviews in a table or view hierarchy
  • Q = Sequence
  • R = User-defined data type
  • S = Materialized query table
  • T = Table (not typed)
  • U = Typed table
  • V = View (not typed)
  • W = Typed view
  • X = Index extension
  • Z = XSR object
  • 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 routine; the null value otherwise.
ROUTINENAME VARCHAR (128)   This column is no longer used and will be removed in a future release. See SPECIFICNAME.