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
- b
- Starting in DB2® V10.1 Fix
Pack 2 and later, this option autobinds missing or invalid packages
to execute SQL statements
- c
- Autocommit SQL statements
- d
- Display the XML declarations of XML data
- e
- Display SQLCODE and 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.