| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| LOCATION |
CHAR(16) NOT NULL |
Always contains blanks |
S |
| COLLID |
CHAR(18) NOT NULL |
Name of the package collection. |
G |
| NAME |
CHAR(8) NOT NULL |
Name of the package. |
G |
| CONTOKEN |
CHAR(8) NOT NULL |
Consistency token for the package. This is either:
° The "level" as specified by the LEVEL option when the package's program was
precompiled
° The timestamp indicating when the package's program was precompiled, in an
internal format |
G |
| SEQNO |
SMALLINT NOT NULL |
Sequence number of the row with respect to a statement in the package (50).
The numbering starts with 0. |
G |
| STMTNO |
SMALLINT NOT NULL |
The statement number of the statement in the source program.
A statement number greater than 32767 is displayed as zero (50) or as a negative
number (51). If the value is zero, see STMTNOI for the statement number. |
G |
| SECTNO |
SMALLINT NOT NULL |
The section number of the statement. (51) |
G |
| BINDERROR |
CHAR(1) NOT NULL |
Whether an SQL error was detected at bind time:
N No
Y Yes |
G |
| IBMREQD |
CHAR(1) NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators intopic D.0 |
G |
| VERSION |
VARCHAR(64) NOT NULL |
Version identifier for the package. |
G |
| STMT |
VARCHAR(254) NOT NULL |
All or a portion of the text for the SQL statement that the row represents. |
S |
| ISOLATION |
CHAR(1) NOT NULL
WITH DEFAULT |
Isolation level for the SQL statement:
R
RR (repeatable read)
T
RS (read stability)
S
CS (cursor stability)
U
UR (uncommitted read)
L
KEEP UPDATE LOCKS for an RS isolation
X
KEEP UPDATE LOCKS for an RR isolation
blank
The WITH clause was not specified on this statement. The isolation level is
recorded in SYSPACKAGE.ISOLATION and in SYSPLAN.ISOLATION. |
G |
| STATUS |
CHAR(1) NOT NULL
WITH DEFAULT |
Status of binding the statement:
A
Distributed - statement uses DB2 private protocol access. The statement
will be parsed and executed at the server using defaults for input
variables during access path selection.
B
Distributed - statement uses DB2 private protocol access. The statement will
be parsed and executed at the server using values for input variables during
access path selection.
C
Compiled - statement was bound successfully using defaults for input
variables during access path selection.
E
Explain - statement is an SQL EXPLAIN statement. The explain is done at
bind time using defaults for input variables during access path selection.
F
Parsed - statement did not bind successfully and VALIDATE(RUN) was used.
The statement will be rebound at execution time using values for input
variables during access path selection.
G
Compiled - statement bound successfully, but REOPT is specified.
The statement will be rebound at execution time using values for input
variables during access path selection.
H
Parsed - statement is either a data definition statement or a statement that
did not bind successfully and VALIDATE(RUN) was used. The statement will
be rebound at execution time using defaults for input variables during
access path selection. Data manipulation statements use defaults for input
variables during access path selection.
I
Indefinite - statement is dynamic. The statement will be bound at execution
time using defaults for input variables during access path selection.
J
Indefinite - statement is dynamic. The statement will be bound at execution
time using values for input variables during access path selection.
K
Control - CALL statement.
L
Bad - the statement has some allowable error. The bind continues but the
statement cannot be executed.
blank
The statement is non-executable, or was bound in a DB2 release prior to
Version 5. |
S |
| ACCESSPATH |
CHAR(1) NOT NULL
WITH DEFAULT |
For static statements, indicates if the access path for the statement is based on
user-specified optimization hints. A value of 'H' indicates that optimization hints were
used. A blank value indicates that the access path was determined without the use of
optimization hints, or that there is no access path associated with the statement.
For dynamic statements, the value is blank. |
G |
| STMTNOI |
INTEGER NOT NULL WITH DEFAULT |
If the value of STMTNO is zero, the column contains the statement number of the
statement in the source program. |
G |
| SECTNOI |
INTEGER NOT NULL
WITH DEFAULT |
The section number of the statement. |
G |
| EXPLAINABLE |
CHAR(1) NOT NULL
WITH DEFAULT |
Contains one of the following values:
Y
Indicates that the SQL statement can be used with the EXPLAIN function and
may have rows describing its access path in the userid.PLAN_TABLE.
N
Indicates that the SQL statement does not have any rows describing its
access path in the userid.PLAN_TABLE.
blank Indicates that the SQL statement was bound prior to Version 7. |
G |
| QUERYNO |
INTEGER NOT NULL
WITH DEFAULT -1 |
The query number of the SQL statement in the source program. SQL statements bound
prior to Version 7 have a default value of -1. Statements bound in Version 7 or later
use the value specified on the QUERYNO clause on SELECT, UPDATE, INSERT, DELETE,
EXPLAIN, and DECLARE CURSOR statements. If the QUERYNO clause is not specified,
the query number is set to the statement number. |
G |
