DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.XSROBJECTDEP catalog view

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

Table 1. SYSCAT.XSROBJECTDEP Catalog View
Column Name Data Type Nullable Description
OBJECTID BIGINT   Unique generated identifier for an XSR object.
OBJECTSCHEMA VARCHAR (128)   Schema name of the XSR object.
OBJECTNAME VARCHAR (128)   Unqualified name of the XSR object.
BTYPE CHAR (1)   Type of object on which there is a dependency. Possible values are:
  • A = Table alias
  • B = Trigger
  • F = Routine
  • G = Global temporary table
  • H = Hierachy table
  • 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 If BTYPE = 'O', 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges on the table or view that are required by a dependent trigger; null value otherwise.