Data Set Options for Relational Databases |
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
|
-
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.
![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
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;
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.