Contains a row for each package that has been created by binding an
application program.
Table 95. SYSCAT.PACKAGES Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
PKGSCHEMA | VARCHAR(128) |
| Name of the package. |
PKGNAME | CHAR(8) |
| |
BOUNDBY | VARCHAR(128) |
| Authorization ID (OWNER) of the binder of the package. |
DEFINER | VARCHAR(128) |
| Userid under which package was bound. |
DEFAULT_SCHEMA | VARCHAR(128) |
| Default schema (QUALIFIER) name used for unqualified names in static SQL statements. |
VALID | CHAR(1) |
|
|
UNIQUE_ID | CHAR(8) |
| Internal date and time information indicating when the package was first created. |
TOTAL_SECT | SMALLINT |
| Total number of sections in the package. |
FORMAT | CHAR(1) |
| Date and time format associated with the package:
|
ISOLATION | CHAR(2) | Yes | Isolation level:
|
BLOCKING | CHAR(1) | Yes | Cursor blocking option:
|
INSERT_BUF | CHAR(1) |
| Insert option used during bind:
|
LANG_LEVEL | CHAR(1) | Yes | LANGLEVEL value used during BIND:
|
FUNC_PATH | VARCHAR(254) |
| The SQL path used by the last BIND command for this package. This is used as the default path for REBIND. SYSIBM for pre-Version 2 packages. |
QUERYOPT | INTEGER |
| Optimization class under which this package was bound. Used for rebind. The classes are: 0, 1, 3, 5 and 9. |
EXPLAIN_LEVEL | CHAR(1) |
| Indicates whether Explain was requested using the EXPLAIN or EXPLSNAP
bind option.
|
EXPLAIN_MODE | CHAR(1) |
| Value of EXPLAIN bind option:
|
EXPLAIN_SNAPSHOT | CHAR(1) |
| Value of EXPLSNAP bind option:
|
SQLWARN | CHAR(1) |
| Are positive SQLCODEs resulting from dynamic SQL statements returned to
the application?
|
SQLMATHWARN | CHAR(1) |
| Value of database configuration parameter DFT_SQLMATHWARN at time of
bind. Are arithmetic errors and retrieval conversion errors in static
SQL statements handled as nulls with a warning?
|
EXPLICIT_BIND_TIME | TIMESTAMP |
| The time at which this package was last explicitly bound or rebound. When the package is implicitly rebound, no function instance will be selected that was created later than this time. |
LAST_BIND_TIME | TIMESTAMP |
| Time at which the package last explicitly or implicitly bound or rebound. |
CODEPAGE | SMALLINT |
| Application codepage at bind time (-1 if not known). |
DEGREE | CHAR(5) |
| Indicates the limit on intra-partition parallelism (as a bind option)
when package was bound.
|
MULTINODE_PLANS | CHAR(1) |
|
|
INTRA_PARALLEL | CHAR(1) |
| Indicates the use of intra-partition parallelism by static SQL statements
within the package.
|
VALIDATE | CHAR(1) |
|
|
DYNAMICRULES | CHAR(1) |
|
|
SQLERROR | CHAR(1) |
| Indicates SQLERROR option on the most recent subcommand that bound or
rebound the package.
|
REFRESHAGE | DECIMAL (20,6) |
| Timestamp duration indicating the maximum length of time between when a REFRESH TABLE statement is run for a summary table and when the summary table is used in place of a base table. |
REMARKS | VARCHAR(254) | Yes | User-supplied comment, or null. |