BL_RECOVERABLE= Data Set Option

Determines whether the LOAD process is recoverable.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	DBMS-specific
Requirement:	To specify this option, you must first set BULKLOAD=YES.
Data source:	DB2 under UNIX and PC Hosts, Oracle
See:	BULKLOAD= data set option

Syntax

Details

Example

Syntax

BL_RECOVERABLE=YES | NO

Syntax Description

YES: specifies that the LOAD process is recoverable. For DB2, YES also specifies that BL_COPY_LOCATION= should specify the copy location for the data.

NO: specifies that the LOAD process is not recoverable.

Details

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.

Example: Specify a Load as Unrecoverable

This Oracle 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;