NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-63
Considerations—SQLCI
With NOWAIT, you should include SET BREAK_KEY OFF as an sqlci-
command option. This strategy prevents SQLCI from taking control from another
process when you press the Break key.
run-option
is an option of the RUN command, which is described in the TACL Reference
Manual.
sqlci-command
is any SQLCI command. You must terminate each SQLCI command with a
semicolon (;), as shown in the command description. After executing the commands
you enter with this option, SQLCI starts reading from the IN file.
Considerations—SQLCI
•
TMF must be enabled while you run SQLCI.
•
In the OSS environment, you can start an SQLCI session by using the gtacl
command. For example, the following command begins an interactive SQLCI
session:
gtacl -p sqlci
To end the SQLCI session and return to the OSS prompt, use the SQLCI EXIT
command. You can also start an SQLCI session, execute SQLCI commands, and
return to the OSS prompt by using the gtacl command with the -c option, as in the
following example:
gtacl -c "sqlci; fileinfo; exit;"
For more information about using the gtacl command in the OSS environment, see
the Open System Services Shell and Utilities Reference Manual or enter the
following command at the OSS prompt:
man gtacl
•
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 command starts a SQLCI session, sets the current default volume and
subvolume to $VOL1.SALES, sets the current catalog to SALES, turns off the