Administration Guide
Contains a row for each dependency that packages have on indexes, tables,
views, functions, aliases, types, and hierarchies.
Table 94. 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.
|
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]