LISTSQLB

#### Search Results

Search

# LISTSQLB

`LISTSQLB`

Notes:

1. This command is only available with Natural for Db2.
2. Before you use the `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).