SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-40
SET SESSION Command
BREAK_KEY { OFF | ON }
specifies the SQLCI action when you press the Break key while executing an SQL
command or an OBEY command.
Use OFF if you want to prevent someone from interrupting commands at your
terminal.
The default when you start SQLCI is BREAK_KEY ON.
DISPLAY_ERROR { MAIN }
{ ALL }
controls which errors SQLCI displays when you enter an ERROR command. The
setting you specify stays in effect until you set or reset it, or until you end your
SQLCI session.
The default when you start SQLCI is DISPLAY_ERROR ALL.
ERROR_ABORT { OFF | ON }
specifies the SQLCI action when an error occurs in a non-interactive SQLCI
session or nested OBEY file. The main level of command is not affected when
processing an interactive SQLCI session except for the completing code settings:
The default when you start SQLCI is ERROR_ABORT OFF.
ERROR_ABORT can be toggled between the ON and OFF settings within a
session as required:
OFF Return control to the previous Break key owner (type PAUSE to resume
SQLCI later)
ON Retain control (the IN file must be a terminal)
MAIN Display first error from most recent command only
ALL Display all errors and warnings from the command
OFF Continue after error
ON Terminate immediately when an error is encountered
Session Type ERROR_ABORT OFF ERROR_ABORT ON
Interactive OK=0 OK=0
Session Warning=0 Warning=0
Error=0 OK=0
Noninteractive OK=0 OK=0
Session Warning=1 Warning=1
Error=2 Error = abend = 5