SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-42
Considerations—SET SESSION
WARNINGS { OFF | ON }
specifies whether to display warning messages. (SQLCI always displays error
messages.)
The default when you start SQLCI is WARNINGS ON.
WRAP { OFF | ON }
specifies whether SQLCI output lines that exceed the output device width are
truncated or continued on the next line.
The default when you start SQLCI is WRAP ON.
Output device widths are:
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 this 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.
OFF Do not display warning messages
ON Display warning messages
OFF Continue (wrap around) to the next line
ON Truncate the line if it does not fit
Terminal 80 bytes
Unstructured Disk File 80 bytes
Structured File Record length of file
Edit File 80 bytes; 239 if RIGHT_MARGIN > 80
Process (for example,
Spooler collector)
132 bytes; 255 if RIGHT_MARGIN > 132
Printer 132 bytes; 255 if RIGHT_MARGIN > 132