NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-45
Examples—SET SESSION
Break key is pressed, 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 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;
To direct SQLCI to display ten rows at a time, enter:
>> SET LIST_COUNT 10;
>>
To enable the display of statistics and disable continuation of text to the next line,
enter:
>> SET STATISTICS ON, WRAP OFF;