Data Set Options for Relational Databases

BL_RECOVERABLE= Data Set Option

Determines whether the LOAD process is recoverable.

Default value:	NO for DB2 under UNIX and PC Hosts, YES for Oracle
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	DB2 under UNIX and PC Hosts, Oracle

Syntax

BL_RECOVERABLE=YES | NO

YES: specifies that the LOAD process is recoverable. For DB2, YES also specifies that the copy location for the data should be specified by BL_COPY_LOCATION=.
NO: specifies that the LOAD process is not recoverable. For Oracle, NO adds the UNRECOVERABLE keyword before the LOAD keyword in the control file.

To specify this option, you must first set BULKLOAD=YES.

Oracle: Set this option to NO to improve direct load performance.

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 for Oracle demonstrates the use of BL_RECOVERABLE= to specify that the load is unrecoverable.

data x.recover_no (bulkload=yes bl_recoverable=no); c1=1; run;