SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-39
SET SESSION Command
SET SESSION Command
SET SESSION is an SQLCI command that sets session options for your SQLCI
session.
You cannot specify the same option more than once in a single 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.
SET [ SESSION ] option [ , option ] ... ;
option is:
{ AUTOWORK [ ON [ AUDITONLY ] | OFF ] }
{ BREAK_KEY { OFF | ON } }
{ DISPLAY_ERROR { MAIN | ALL } }
{ ERROR_ABORT { OFF | ON } }
{ ERROR_TEXT { DETAIL | BRIEF } }
{ LIST_COUNT { number| ALL } }
{ MANDATORY_REPORT { OFF | ON } }
{ STATISTICS { OFF | ON } }
{ WARNINGS { OFF | ON } }
{ WRAP { OFF | ON } }