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 -n Remove new line character 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.