ISQL and Tools
3-38 FairCom Corporation
____________________
EDITOR ..................... : vi
HISTORY buffer size ........ : 50 PAUSE ..................... : ON
COMMAND LINES .............. : 10 TIMEing command execution.. : OFF
SPOOLing ................... : ON LINESIZE .................. : 78
REPORTing Facility ......... : ON PAGESIZE .................. : 72
Spool File ................. : spool_file
AUTOCOMMIT ................. : OFF ECHO commands ............. : ON
TRANSACTION ISOLATION LEVEL. : 0 (Snapshot)
DATABASE CONNECTIONS
_______________________
DATABASE CONNECTION NAME IS DEFAULT ? IS CURRENT ?
-------- --------------- ------------ -----------
salesdb conn_1 No Yes
3.7.20 SPOOL
Syntax
SPOOL filename [ON] ;
SPOOL OFF ;
SPOOL OUT ;
Description
The SPOOL statement writes output from interactive SQL statements to the specified file.
Arguments
filename ON
Opens the file specified by filename and writes the displayed output into that file. The filename
cannot include punctuation marks such as a period (.) or comma (,).
OFF
Closes the file opened by the SPOOL ON statement.
OUT
Closes the file opened by the SPOOL ON statement and prints the file. The SPOOL OUT
statement passes the file to the system utility statement pr and the output is piped to lpr.
