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
- Autobind missing or invalid packages that are required
to run 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
- y
- Get SQL message text from connected database server.
- 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.
DB2 10.5 for Linux, UNIX, and Windows