UPDATE COMMAND OPTIONS command

The UPDATE COMMAND OPTIONS command 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

Read syntax diagramSkip visual syntax diagramUPDATE COMMAND OPTIONS USINGoption-letterONvalueOFF

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.