SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
O-7
OUT Command
create, compile, execute, and maintain the program. NonStop SQL/MP uses the ZYQ
name to identify the file in an SQL/MP catalog.
To determine a pathname from a ZYQ name, use the DETAIL option on the FILEINFO
or FUP INFO command. Both these commands return one of the pathnames of an
OSS file as part of the DETAIL display.
OUT Command
OUT is an SQLCI command that directs SQLCI output to a specific file or closes the
current OUT file and redirects output to the initial OUT file.
list-file
is the name of the file to which you want the output written. For list-file,
specify a device, disk, or process file. The OUT file cannot be the same file as any
other current output file such as the LOG, INVOKE TO, or OUT_REPORT file
unless the file is a terminal or process. The OUT file can be the same as the IN file.
If you omit list-file, SQLCI closes the current OUT file and sends output to the
file that was the OUT file at the beginning of the SQLCI session (usually your
terminal).
If you specify a nonexistent disk file as list-file, SQLCI creates an EDIT file of
that name.
CLEAR
clears the new OUT file before anything is written to it. If you omit this option,
information is appended to the file. CLEAR is ignored unless the file is a disk or
process file.
Consideration—OUT
SQLCI writes all information that it produces to the OUT file, including output from
commands such as SHOW and DISPLAY STATISTICS, data from SELECT commands
(unless you specify an OUT_REPORT file), and diagnostic messages. SQLCI also
writes the final version of any command you fix with FC command to the OUT file, but
not the characters you enter while fixing it.
If the IN file is the same as the OUT file (which is the case in interactive usage), SQLCI
also writes the current prompt and lines that you enter to the OUT file.
SQLCI ejects a page before and after each report from a SELECT command. If the
OUT file is a spooler file and you do not specify an OUT_REPORT file, each report
appears on a separate page (or pages) and does not include the SELECT command or
diagnostic messages.
OUT [ list-file [ CLEAR ] ] ;