A new data set option, BL_RECOVERABLE, is available for SAS/ACCESS Interface to DB2 on Linux, UNIX, and Windows hosts. The option determines whether the LOAD process is recoverable. 

This data set option applies only in cases in which you create 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.

For more information about this option, see the BL_RECOVERABLE= Data Set Option section in SAS/ACCESS^® 9.4 for Relational Databases: Reference, Ninth Edition.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at

Viya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at

A fix for this issue for SAS/ACCESS Interface to DB2 9.43 is available at: