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	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.