Command Reference

UPDATE COMMAND OPTIONS

Sets one or more command options during an interactive session, or from a batch input file. The settings revert to system defaults (or the system default overrides in DB2OPTIONS) when the interactive session or batch input file ends.

Authorization

None

Required Connection

None

Command Syntax

>>-UPDATE COMMAND OPTIONS USING--------------------------------->
 
      .---------------------------------.
      V                                 |
>--------option-letter--+-ON--value--+--+----------------------><
                        '-OFF--------'
 

Command Parameters

USING option-letter

The following option-letters can be set:

a

Display SQLCA

c

Auto-commit SQL statements

e

Display SQLCODE/SQLSTATE

l

Log commands in a history file

o

Display to standard output

p

Display DB2 interactive prompt

r

Save output report to a file

s

Stop execution on command error

v

Echo current command

w

Show SQL statement warning messages

z

Redirect all output to a file.

ON value

The e, l, r, and z options require a value if they are turned on. For the e option, value can be c to display the SQLCODE, or s to display the SQLSTATE. For the l, r, and z options, value represents the name to be used for the history file or the report file. No other options accept a value.

Usage Notes

These settings override system defaults, settings in DB2OPTIONS, and options specified using the command line option flags.

The file input option (-f) and the statement termination option (-t) cannot be updated using this command.

To view the current option settings, use LIST COMMAND OPTIONS.

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

[ DB2 List of Books | Search the DB2 Books ]