SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-44
Examples—SET SESSION
where file is an interactive device; typically a terminal (device type 6) or a
process (device type 0)

SQLCI /INLINE/

SQLCI /INV variable, OUTV variable/
The use of TACL INLINE and INV/OUTV are special cases of a process device
type classification.
Non-interactive processing includes:

SQLCI /IN file,.../
where file is any disk file or non-interactive device

Any nested OBEY file
Examples—SET SESSION

To set the AUTOWORK option to OFF, enter:
>> SET AUTOWORK OFF;
To set AUTOWORK to ON and specify the AUDITONLY option, enter:
>> SET AUTOWORK ON AUDITONLY;

To protect an update operation, you can disable the Break key before running the
OBEY command file ORDUPDT. The commands in this file update the ORDERS
table. If you press the Break key, SQLCI returns control to the command interpreter
until you type PAUSE to resume your operation.
>> SET BREAK_KEY OFF;
>> OBEY ORDUPDT;
(Break key is pressed.)
5> PAUSE

Suppose that the BREAK_KEY option is ON. During a TMF transaction that
updates the price of each part in the PARTS table by 5 percent, you press the
Break key. SQLCI rolls back the transaction.
>> SET BREAK_KEY ON;
>> BEGIN WORK;
>> UPDATE INVENT.PARTS SET PRICE = PRICE * 1.O5;
(Break key is pressed.)
*** ERROR [10088] Command terminated by BREAK

To set the DISPLAY_ERROR option to MAIN, enter:
>> SET DISPLAY_ERROR MAIN;

To set the ERROR_TEXT option to BRIEF, enter:
>> SET ERROR_TEXT BRIEF;