DB2 Server for VSE & VM: Interactive SQL Guide and Reference

LIST



                  .------------------------------.
                  V                              |
>>-LIST----+-SQL------+-stored-statement-name-+--+-+-----------><
           |          '-*---------------------'    |
           |      .----------------------.         |
           |      V                      |         |
           '-SET----+-*---------------+--+---------'
                    +-AUTOCommit------+
                    +-CASE------------+
                    |       (1)       |
                    +-CLAss-----------+
                    +-CONTInue--------+
                    |        (1)      |
                    +-COPies----------+
                    +-COSTest---------+
                    +-DECimal---------+
                    +-ISOLation-------+
                    +-LANGuage--------+
                    +-NULL------------+
                    +-PAGEsize--------+
                    |            (1)  |
                    +-PRINTRoute------+
                    +-RUNMode---------+
                    +-SEParator-------+
                    '-VARChar---------'


Notes:



  1. The parameters CLAss, COPies, and PRINTRoute are not applicable to
    VM.


LIST is an ISQL command that lists information about stored SQL statements or the settings of operational characteristics set by the SET command.

SQL
lists stored SQL statement(s) on the display. See STORE for more information.

stored_statement_name
is the name of the stored SQL statement to be listed. The entire statement stored with the specified name is displayed.

*
specifies that all your stored SQL statements are to be listed. The name of each statement and its first 50 characters are displayed.

SET
lists the current operational characteristics in effect for the specified function of the SET command. For example, if you type: 
   list set continue

the current continuation character is displayed. Valid functions are any of those functions performed by the SET command.

If * is specified, the current operational characteristics in effect for all SET command functions are listed. For a description of the SET characteristics, see SET. for more information.

Examples

The LIST command can be used with more than one keyword option in a single command. For example, if you want to display more than one operational characteristic, you can type: 

   list set page case null

If you want to display more than one stored SQL statement, you can type: 

   list sql myquery query1

Stored SQL statements and operational characteristics may not be listed at the same time.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]