NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-40
SET SESSION Command
AUTOWORK [ ON [ AUDITONLY ] | OFF ]
specifies whether SQLCI should automatically initiate a TMF transaction when you
enter a DML command and how locking works in relation to nonaudited objects
locked during the transaction.
ON [ AUDITONLY ]
directs SQLCI to start a TMF transaction when you enter a DML command, to
commit the transaction if the command terminates successfully or to roll back
the transaction if the command does not complete successfully, and to release
locks on objects after execution of the command.
If you specify AUDITONLY, SQLCI does not release locks on nonaudited
objects when the transaction is committed or rolled back.
The default when you start SQLCI is AUTOWORK ON (without
AUDITONLY).
OFF
directs SQLCI not to start transactions automatically.
BREAK_KEY { OFF | ON }
specifies the SQLCI action when you press the Break key while executing an SQL
command or an OBEY command.
Use OFF if you want to prevent someone from interrupting commands at your
terminal.
The default when you start SQLCI is BREAK_KEY ON.
DISPLAY_ERROR { MAIN }
{ ALL }
controls which errors SQLCI displays when you enter an ERROR command. The
setting you specify stays in effect until you set or reset it, or until you end your
SQLCI session.
The default when you start SQLCI is DISPLAY_ERROR ALL.
OFF Return control to the previous Break key owner (type PAUSE to resume
SQLCI later)
ON Retain control (the IN file must be a terminal)
MAIN Display first error from most recent command only
ALL Display all errors and warnings from the command