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.
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
- d
- Display the XML declarations of XML data
- e
- Display SQLCODE/SQLSTATE
- i
- Display XQuery results with proper indentation
- l
- Log commands in a history file
- m
- Display the number of rows affected by INSERT, DELETE, UPDATE
or MERGE statements.
- n
- Remove new line character
- o
- Display to standard output
- p
- Display DB2® interactive
prompt
- q
- Preserve whitespace and line feeds in strings delimited with single
or double quotation marks.
- 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 the LIST COMMAND OPTIONS command.