NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-39
SET SESSION Command
The following values are inserted in ORDERS:
After setting a different order number and customer number, you execute the OBEY
file again:
>> SET PARAM ?ONUM 600481, ?CUSTNUM 123;
>> OBEY INSORD;
The following values are inserted into ORDERS:
When you exit SQLCI, the values of ?ONUM and ?CUSTNUM are 400410 and
7654, respectively, as set initially by the PARAM 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.
ORDERNUM 600480
ORDER_DAT
E
(timestamp for current date and time)
DELIV_DATE (timestamp for 7/5/88)
SALESREP 221
CUSTNUM 7654
ORDERNUM 600481
ORDER_DAT
E
(timestamp for current date and time)
DELIV_DATE (timestamp for 7/5/88)
SALESREP 221
CUSTNUM 123
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 } }