Specifies whether SAS creates a utility spool file during Read transactions that read data more than once.
Valid in: | LIBNAME statement |
Default: | YES |
Supports: | All |
specifies that SAS creates a utility spool file into which it writes the rows that are read the first time. For subsequent passes through the data, the rows are read from the utility spool file rather than being reread from the data source table. This guarantees that the rowset is the same for every pass through the data.
specifies that the required rows for all passes of the data are read from the data source table. No spool file is written. There is no guarantee that the rowset is the same for each pass through the data.
is valid for Oracle only. The required rows for all passes of the data are read from the DBMS table but additional enforcements are made on the DBMS server side to ensure that the rowset is the same for every pass through the data. This setting causes the Oracle driver to satisfy the two-pass requirement by starting a Read-only transaction. SPOOL=YES and SPOOL=DBMS have comparable performance results for Oracle. However, SPOOL=DBMS does not use any disk space. When SPOOL is set to DBMS, the CONNECTION option must be set to UNIQUE. If not, an error occurs.