SYSIBM.SYSPACKSTMT table
The SYSIBM.SYSPACKSTMT table contains one or more rows for each statement in a package.
Column name | Data type | Description | Use |
---|---|---|---|
LOCATION |
VARCHAR(128)
NOT NULL
|
Always contains blanks | S |
COLLID |
VARCHAR(128)
NOT NULL
|
Name of the package collection. | G |
NAME |
VARCHAR(128)
NOT NULL
|
Name of the package. | G |
CONTOKEN |
CHAR(8)
NOT NULL
FOR BIT DATA
|
Consistency token for the package. This is either:
|
S |
SEQNO |
INTEGER
NOT NULL
|
Not used. | G |
STMTNO |
SMALLINT
NOT NULL
|
The statement number of the statement in the source program. A statement number greater than 32767 is stored as zero1 or as a negative number2. If the value is zero, see STMTNOI for the statement number. | G |
SECTNO |
SMALLINT
NOT NULL
|
The section number of the statement.2 | G |
BINDERROR |
CHAR(1)
NOT NULL
|
Whether an SQL error was detected at bind time:
|
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.
The value in this field is not a reliable indicator of release dependencies. |
G |
VERSION |
VARCHAR(122)
NOT NULL
|
Version identifier for the package. | G |
VARCHAR(3500)
NOT NULL WITH
DEFAULT
FOR BIT DATA
|
Internal use only. | I | |
ISOLATION |
CHAR(1)
NOT NULL WITH
DEFAULT
|
Isolation level for the SQL statement:
|
G |
STATUS |
CHAR(1)
NOT NULL WITH
DEFAULT
|
Status of binding the statement:
|
S |
STATUS (cont.) |
|
||
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:
|
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. If both STMTNO and STMTNOI are zero, the statement number is greater than 32767. | 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:
|
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, DECLARE CURSOR, or REFRESH TABLE statements. If the QUERYNO clause is not specified, the query number is set to the statement number. | G |
ROWID |
ROWID
NULL GENERATED
ALWAYS
|
ROWID column, created for the lob columns in this table. | G |
STMT_ID |
BIGINT
NOT NULL
|
A unique statement identifier. | G |
STATEMENT |
CLOB(2M)
NOT NULL
WITH DEFAULT
|
The complete text for the SQL statement that the row represents. | G |
BLOB(2M)
NOT NULL
WITH DEFAULT
|
Internal use only. | I |
1 Rows in which the value of SEQNO, STMTNO, and SECTNO are zero are for internal use.
2 To convert a negative STMTNO to a meaningful statement number that corresponds to your precompile output, add 65536 to it. For example, -26472 is equivalent to +39064 (-26472 + 65536).