Contains a row for each package that has been created by binding an
application program.
Table 80. SYSCAT.PACKAGES Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PKGSCHEMA | CHAR(8) |
| Name of the package. |
| PKGNAME | CHAR(8) |
| |
| BOUNDBY | CHAR(8) |
| Authorization ID of the binder of the package. |
| DEFINER | CHAR(8) |
| Userid under which package was bound. |
| DEFAULT_SCHEMA | CHAR(8) |
| Default schema name used for unqualified names in static SQL statements. |
| VALID | CHAR(1) |
|
Y=Valid
N=Not valid
X=Package is inoperative because some
function instance that it depends on
has been dropped. Explicit rebind
is needed. See Note 1 on
"SYSCAT.PACKAGEDEP"
|
| 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:
0=Format associated with country code
of the database
1=USA date and time
2=EUR date, EUR time
3=ISO date, ISO time.
4=JIS date, JIS time.
5=LOCAL date, LOCAL time.
|
| ISOLATION | CHAR(2) | Yes | Isolation level:
RR=Repeatable read RS=Read stability CS=Cursor stability UR=Uncommitted read. |
| BLOCKING | CHAR(1) | Yes | Cursor blocking option:
N=No blocking U=Block unambiguous cursors B=Block all cursors |
| INSERT_BUF | CHAR(1) |
| Insert option used during bind:
Y=Inserts are buffered N=Inserts are not buffered |
| LANG_LEVEL | CHAR(1) | Yes | LANGLEVEL value used during BIND:
0=SAA1 1=SQL92E or MIA |
| 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.
Blank=No Explain requested P=Plan Selection level |
| EXPLAIN_MODE | CHAR(1) |
| Value of EXPLAIN bind option:
Y=Yes (static) N=No A=All (static and dynamic) |
| EXPLAIN_SNAPSHOT | CHAR(1) |
| Value of EXPLSNAP bind option:
Y=Yes (static) N=No A=All (static and dynamic) |
| SQLWARN | CHAR(1) |
| Are positive SQLCODES resulting from dynamic SQL statements returned to
the application?
Y=Yes N=No, they are suppressed |
| 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?
Y=Yes N=No, they are suppressed |
| 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.
1 = No intra-partition parallelism.
2 - 32767 = Degree of intra-partition parallelism.
ANY = Degree was determined by the
database manager.
|
| MULTINODE_PLANS | CHAR(1) |
|
Y =Package was bound in a multiple partition environment. N =Package was bound in a single partition environment. |
| INTRA_PARALLEL | CHAR(1) |
| Indicates the use of intra-partition parallelism by static SQL statements
within the package.
Y = one or more static SQL statement in
package uses intra-partition parallelism.
N = no static SQL statement in package uses
intra-partition parallelism.
F = one or more static SQL statement in
package can use intra-partition parallelism;
this parallelism has been disabled for use
on a system that is not configured for
intra-partition parallelism.
|
| REMARKS | VARCHAR(254) | Yes | User-supplied comment, or null. |