This table lets you view the SQL statement source for executing SQL statements. It provides the source in a series of rows containing 80-byte segments. The SEGMENT_SEQUENCE column contains a number indicating the segment of the statement source represented by the row, the first row having a SEGMENT_SEQUENCE of 1.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
ACCESSOR_ID
|
CHAR(18) |
No |
The security accessor ID of the person executing the plan. |
|
BIND_METHOD |
CHAR(11) |
No |
Indicates PERMANENT if the statement was statically prepared (and will be permanently stored in the DBMS), otherwise indicates TEMPORARY. |
|
JOB_NAME
|
CHAR(8) |
No |
The job name of the application. |
|
MUF_NAME
|
CHAR(8) |
No |
Logical name for this MUF. |
|
PLAN_AUTH
|
CHAR(18) |
No |
The authorization ID of the plan. |
|
PLAN_NAME
|
CHAR(18) |
No |
Shows the plan name. |
|
RUN_UNIT
|
INTEGER |
No |
Shows the run unit number (a sequential number assigned to each job using the MUF). |
|
SOURCE_SEGMENT |
CHAR(80) |
Yes |
Contains the text of the SQL statement, or NULL if no text is currently available. |
|
SEGMENT_SEQUENCE |
SMALLINT |
No |
Identifies the segment of source represented by this row. The first segment is segment 1. |
|
STMT_ID
|
INTEGER |
No |
This identifier distinguishes the statement from others in the plan. |
|
TERM_ID
|
CHAR(4) |
No |
Identifies the terminal from which a CICS user is running. |
|
TSK_NBR
|
SMALLINT |
No |
The number of the task in the MUF that is executing this statement. |
|
Copyright © 2014 CA.
All rights reserved.
|
|