LISTSQLB |
Notes:
LISTSQLB
command, refer to
LISTSQL and Explain Functions in the section Installing Natural for Db2 on
z/OS in the Installation for z/OS
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 data set referred to by DD name
CMPRINT
(logical printer 0).