The BL_RECOVERABLE option was added. It can be set to NO to improve direct load performance. Setting this option to NO will add UNRECOVERABLE in the control file just before the LOAD keyword. However, the default value is YES which will not change the existing behavior of what is currently happening without the option.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | SAS/ACCESS Interface to Teradata | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to Sybase | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to R/3 | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to SAP BW | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to PeopleSoft | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to Oracle Rdb | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to OLE DB | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to MySQL | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to Informix | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to IMS-DL/I | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to DB2 Server for VM | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to DB2 | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to CA-IDMS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to CA-OpenIngres | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to Baan | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to CA-Datacom/DB | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 | |||
SAS System | SAS/ACCESS Interface to Adabas | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |||
Linux | 9.1 TS1M3 | |||
HP-UX IPF | 9.1 TS1M3 | |||
64-bit Enabled HP-UX | 9.1 TS1M3 | |||
64-bit Enabled AIX | 9.1 TS1M3 | |||
Tru64 UNIX | 9.1 TS1M3 |
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#015398A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#015398Type: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> Procedures ==> ACCESS |
Date Modified: | 2005-10-10 08:51:14 |
Date Created: | 2005-05-27 14:53:13 |