IBM Books

Command Reference

LIST COMMAND OPTIONS

Lists the current settings for the environment variables:

Authorization

None

Required Connection

None

Command Syntax

>>-LIST COMMAND OPTIONS----------------------------------------><
 

Command Parameters

None

Examples

The following is sample output from LIST COMMAND OPTIONS:



     Command Line Processor Option Settings
 
 Backend process wait time (seconds)        (DB2BQTIME) = 1
 No. of retries to connect to backend        (DB2BQTRY) = 60
 Request queue wait time (seconds)          (DB2RQTIME) = 5
 Input queue wait time (seconds)            (DB2IQTIME) = 5
 Command options                           (DB2OPTIONS) = 
 
 Option  Description                               Current Setting
 ------  ----------------------------------------  ---------------
   -a    Display SQLCA                             OFF
   -c    Auto-Commit                               ON
   -e    Display SQLCODE/SQLSTATE                  OFF
   -f    Read from input file                      OFF
   -l    Log commands in history file              OFF
   -o    Display output                            ON
   -p    Display interactive input prompt          ON
   -r    Save output to report file                OFF
   -s    Stop execution on command error           OFF
   -t    Set statement termination character       OFF
   -v    Echo current command                      OFF
   -w    Display FETCH/SELECT warning messages     ON
   -z    Save all output to output file            OFF

Usage Notes

For detailed information about these options, see Command Line Processor Options.


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

[ DB2 List of Books | Search the DB2 Books ]