Determines whether the LOAD process is recoverable.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | DBMS-specific |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | DB2 under UNIX and PC Hosts, Oracle |
| See: | BULKLOAD= data set option |
Table of Contents
specifies that the LOAD process is recoverable. For DB2, YES also specifies that BL_COPY_LOCATION= should specify the copy location for the data.
specifies that the LOAD process is not recoverable.
DB2 under UNIX and PC Hosts: The default is NO.
Oracle: The default is YES. Set this option to NO to improve direct load performance. Specifying NO adds the UNRECOVERABLE keyword before the LOAD keyword in the control file.
CAUTION
Be aware that an unrecoverable load does not log loaded data into the redo log file. Therefore, media recovery is disabled for the loaded table. For more information about the implications of using the UNRECOVERABLE parameter in Oracle, see your Oracle utilities documentation.
This example shows how to use BL_RECOVERABLE= to specify that the load is unrecoverable.
data x.recover_no (bulkload=yes bl_recoverable=no); c1=1; run;