SQL Reference

SYSCAT.PACKAGES

Contains a row for each package that has been created by binding an application program.

Table 75. 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)

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.

P = Plan Selection level
Blank if 'No' Explain requested

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 - 32 767 = 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.

VALIDATE CHAR(1)

B = All checking must be performed during BIND
R = Reserved

DYNAMICRULES CHAR(1)

B = Dynamic SQL statements are handled like static SQL statements at run time; binder's authid is used.
R = Dynamic SQL statements are handled like dynamic SQL statements at run time; executer's authid is used.
Initial value is R.
SQLERROR CHAR(1)
Indicates SQLERROR option on the most recent subcommand that bound or rebound the package.

C = Reserved
N = No 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.

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)		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. P = Plan Selection level Blank if 'No' Explain requested
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 - 32 767 = 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.
VALIDATE	CHAR(1)		B = All checking must be performed during BIND R = Reserved
DYNAMICRULES	CHAR(1)		B = Dynamic SQL statements are handled like static SQL statements at run time; binder's authid is used. R = Dynamic SQL statements are handled like dynamic SQL statements at run time; executer's authid is used. Initial value is R.
SQLERROR	CHAR(1)		Indicates SQLERROR option on the most recent subcommand that bound or rebound the package. C = Reserved N = No 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.

[ Top of Page | Previous Page | Next Page ]