NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-43
Considerations—SET SESSION
Output device widths are as follows:
Considerations—SET SESSION
•
You can set up your SQLCI session environment by including the sqlci-
command option when you start SQLCI. For example, you might create an OBEY
command file named PROFILE that contains these commands:
VOLUME $VOL1.SALES;
CATALOG SALES;
SET SESSION AUTOWORK OFF, BREAK_KEY OFF;
LOG SQLCILOG;
Then you can prepare your environment quickly by entering the following
command:
SQLCI OBEY PROFILE;
This starts an SQLCI session, sets the current default volume and subvolume to
$VOL1.SALES, sets the current catalog to SALES, turns off the AUTOWORK and
BREAK_KEY session options, and begins logging session input and output to the
file SQLCILOG.
•
Break key
SQLCI responds to the Break key based on the setting of the BREAK_KEY session
option as follows:
Terminal 80 bytes
Disk File
Unstructured or EDIT
80 bytes
Structured Record length of file
Process (for example,
Spooler or background)
132 bytes; 255 if RIGHT_MARGIN > 132)
Printer 132 bytes; 255 if RIGHT_MARGIN > 132
Executing Command
BREAK_KEY
ON
BREAK_KEY
OFF
BREAK_KEY
ON or OFF
SQL commands Command rolls
back; SQLCI
prompts.
Control returns
to previous
owner.