Manualshelf

NonStop SQL/MP Reference Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series
591592593594595596597598599600
Table Of Contents
NonStop SQL/MP Reference Manual—142115
O-7
OUT COMMAND
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.
Considerations—OUT
•
Contents of the OUT file
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 ] ] ;