Version 4.2.6 for Mainframes (Update)
 —  System Commands  —

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 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:

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).

Top of page