LISTSQLB |
Notes:
LISTSQLB command,
refer to
LISTSQL and Explain
Functions in the section Special Requirements for Natural
Tools for DB2 in the Natural for DB2
documentation.
The command LISTSQLB can be executed in batch
mode or issued online from the Natural NEXT prompt.
If executed online, the following screen is invoked:
10:54:35 ***** NATURAL Tools for SQL ***** 2006-03-17
- LISTSQLB -
Code Function
X Explain all SQL Statements
. Exit
Code .. _ Member ... ________
Queryno .. 1____
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Exit Canc |
By specifying a valid member name, the explanation of SQL statements can be limited to certain member(s); an asterisk (*) can be used for range specification:
If you specify a unique member name, all SQL statements contained in this member are explained;
If you specify a value followed by an asterisk, all SQL statements contained in all members with names beginning with the specified value are explained;
If you specify an asterisk only (or leave the field blank), all SQL statements of all existing SQL members are explained.
A query number must be specified, so that with each issued
EXPLAIN command, the newly created explanation is
added to the appropriate query number. The default query number is
1.
To issue the EXPLAIN command, enter function
code X and specify a valid member name and query number; all SQL
statements contained in the specified member(s) are explained.
If LISTSQLB is executed online, the following screen informs
you about the processing status of the command and if any errors have
occurred.
10:55:24 ***** NATURAL Tools for SQL ***** 2006-03-17
- LISTSQLB -
Queryno : 1 Member Stmtno Message
Current Object :
Library TEST
Member RTTB--IN
Statistics :
Members read 1
with SQL 1
SQL statements 7
Member Message
RTTB--IN OK
Press Enter to continue
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- |
If executed in batch mode, error messages are written to a dataset
referred to by DD name CMPRINT (logical printer 0).
