SQL Statement Selection
The SQL Statement Selection screen (see the following figure) displays when a DBRM or package is selected with the S line command on the DBRM/Package Selection screen (DBRM/Package Selection Screen) or the DBRM Selection screen (DBRM Selection Screen).
SQL Statement Selection Screen
File-AID for DB2 --------- SQL Statement Selection ---------------- SSID: DSN
COMMAND ===> SCROLL ===> PAGE
PLAN NAME/COLLID : FDRWATST PRECOMPILE TIMESTAMP: 08-10-24 14.58.44.46
DBRM/PACKAGE NAME: OSSOLCAT
Line Commands:
X - Explain the selected SQL statement
CMD STMT SQL TEXT
_ 11651 SELECT FDLPROC
INTO :SQLFPROC
FROM SYSIBM . SYSFIELDS
WHERE TBCREATOR = :SQLTCREA
AND TBNAME = :SQLTNAME
_ 12268 DECLARE KEYS_CURSOR CURSOR FOR
SELECT COLNAME , COLNO , COLSEQ , ORDERING
FROM SYSIBM . SYSKEYS
WHERE IXNAME = :SQLINAME
AND IXCREATOR = :SQLICREA
COMMAND ===> SCROLL ===> PAGE
PLAN NAME/COLLID : FDRWATST PRECOMPILE TIMESTAMP: 08-10-24 14.58.44.46
DBRM/PACKAGE NAME: OSSOLCAT
Line Commands:
X - Explain the selected SQL statement
CMD STMT SQL TEXT
_ 11651 SELECT FDLPROC
INTO :SQLFPROC
FROM SYSIBM . SYSFIELDS
WHERE TBCREATOR = :SQLTCREA
AND TBNAME = :SQLTNAME
_ 12268 DECLARE KEYS_CURSOR CURSOR FOR
SELECT COLNAME , COLNO , COLSEQ , ORDERING
FROM SYSIBM . SYSKEYS
WHERE IXNAME = :SQLINAME
AND IXCREATOR = :SQLICREA
CMD
Specify the line command to be performed on the selected SQL statement:
X | Enter X to perform an Explain of the selected SQL statement. The Plan Table Analysis screen (Plan Table Analysis Screen) displays. |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*