SQL Reference

SYSCAT.PACKAGEDEP

Contains a row for each dependency that packages have on indexes, tables, views, functions, aliases, types, and hierarchies.

Table 74. SYSCAT.PACKAGEDEP Catalog View

Column Name	Data Type	Nullable	Description
PKGSCHEMA	VARCHAR(128)		Name of the package.
PKGNAME	CHAR(8)
BINDER	VARCHAR(128)	Yes	Binder of the package.
BTYPE	CHAR(1)		Type of object BNAME: A = Alias D = Server definition F = Function instance I = Index M = Function mapping N = Nickname O = Privilege dependency on all subtables or subviews in a table or view hierarchy P = Page size R = Structured type S = Summary table T = Table U = Typed table V = View W = Typed view
BSCHEMA	VARCHAR(128)		Qualified name of an object on which the package is dependent.
BNAME	VARCHAR(128)
TABAUTH	SMALLINT	Yes	If BTYPE is O, S, T, U, V or W then it encodes the privileges that are required by this package (Select, Insert, Delete, Update).
Note: When a depended-on function-instance is dropped, the package is placed into an "inoperative" state from which it must be explicitly rebound. When any other depended-on object is dropped, the package is placed into an "invalid" state from which the system will attempt to rebind it automatically when a package is first referenced.