Determines whether the LOAD process is recoverable.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | NO |
| Restriction: | This option applies only when you use a CREATE TABLE AS SELECT statement with the LOAD FROM CURSOR method. |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Interaction: | To view log information related to this option, specify a log file for the BL_LOG= option. |
| Data source: | DB2 under UNIX and PC Hosts |
| Note: | Support for this option was added in SAS Viya 3.5. |
| See: | BL_LOG= LIBNAME option, BL_RECOVERABLE= data set option, BULKLOAD= LIBNAME option, SASTRACE= system option |
Table of Contents
specifies that the LOAD process is recoverable.
specifies that the LOAD process is not recoverable.
This LIBNAME option applies only in the case where you are creating a table in a DB2 location from a table that resides in a DB2 location. In this case, a CREATE TABLE AS SELECT statement is passed to the database for processing. To see the SQL code that is generated, specify the SASTRACE= system option.