SYSCAT.PACKAGEDEP catalog view
Each row represents a dependency of a package on some other object. The package depends on the object of type BTYPE of name BNAME, so a change to the object affects the package.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
PKGSCHEMA | VARCHAR (128) | Schema name of the package. | |
PKGNAME | VARCHAR (128) | Unqualified name of the package. | |
BINDER | VARCHAR (128) | Binder of the package. | |
BINDERTYPE | CHAR (1) |
|
|
BTYPE | CHAR (1) | Type of object on which there is a dependency. Possible values
are:
|
|
BSCHEMA | VARCHAR (128) | Schema name of an object on which the package depends. | |
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 an object on which the package depends. | |
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
If BTYPE is 'O', 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges that are required
by this package (SELECT, INSERT, UPDATE, or DELETE).<install path>/include/sql.h and are as follows:
|
VARAUTH | SMALLINT | Y | If BTYPE is 'v', encodes the privileges that are required by this package (READ or WRITE). |
UNIQUE_ID | CHAR (8) FOR BIT DATA | Identifier for a specific package when multiple packages having the same name exist. | |
PKGVERSION | VARCHAR (64) | Y | Version identifier for the package. |
Note:
|