SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-61
The SQLCI Command
Within an SQLCI session, the tasks you perform are affected by these session
attributes:
The SQLCI Command
The SQLCI command is a TACL implied run command that starts an SQLCI session. In
the OSS environment, you can invoke the SQLCI command by preceding it with the
gtacl command. For more information about SQLCI and OSS, see Considerations—
SQLCI on page S-62.
IN in-file
specifies the file from which SQLCI reads your commands; in-file is a valid
Guardian name for a local or remote file. You can specify a disk file, a device such
as a terminal, or a process. If you do not specify an IN file, SQLCI uses the same
IN file as the command interpreter—usually the home terminal.
Environment The files to use for SQLCI output, logging, and reports; the
default node, volume, subvolume, and catalog
DEFINEs DEFINEs that associate an actual file or object with a logical
name used in a command or statement
Session Options Options set by the SET SESSION command that control the
response to the Break key, automatic creation of TMF
transactions, the amount of SELECT information displayed
before a pause, the display of execution statistics for DML
statements, the display of errors and warnings, and the
wrapping of text
Layout Options Options set by the SET LAYOUT command that define the
layout of information displayed after a SELECT
Style Options Options set by the SET STYLE command that determine the
style of report elements such as date and time formats and the
underline character
Parameters Parameter values set by the SET PARAM command to
substitute for parameter names when a command or statement
executes
Prepared
Commands
Commands compiled during an SQLCI session for execution
later in the session
Report Commands Report formatting commands and the most recent SELECT
command entered. SQLCI saves these commands
automatically during your session. You can display, delete, or
fix and reexecute these commands with SHOW, RESET, or FC.
SQLCI [ / [ IN in-file ] [, OUT list-file ] [, NOWAIT ]
[, run-option ] ... / ] [ sqlci-command ; ] ...