Problem Note 40886: Records are not inserted properly when you use the DBMSTEMP= LIBNAME option in SAS/ACCESS® Interface to Netezza
 |  |  |  |  |
The DBMSTEMP= LIBNAME option specifies whether the SAS® System creates temporary or permanent tables. By default, the value for this option is NO, meaning that SAS creates permanent tables.
However, when you use DBMSTEMP=YES and you specify either CONNECTION=GLOBAL or CONNECTION=SHARED, records that are inserted using explicit pass-through processing are not committed (saved) correctly. These records are rolled back (that is, the records revert back to their prior status) during the commit that immediately follows the explicit connection.
As a workaround, use the AUTOCOMMIT=YES LIBNAME option. Using this option commits all updates, deletions, and insertions to a table immediately after they are submitted. In addition, no rollback is possible.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | Microsoft® Windows® for x64 | 9.22_M2 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.22_M2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.22_M2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.22_M2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 for x64 | 9.22_M2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2008 | 9.22_M2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2008 for x64 | 9.22_M2 | 9.2 TS2M2 | ||||
| Microsoft Windows XP Professional | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows 7 Enterprise 32 bit | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows 7 Enterprise x64 | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows 7 Home Premium 32 bit | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows 7 Home Premium x64 | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows 7 Professional 32 bit | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows 7 Professional x64 | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows 7 Ultimate 32 bit | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows 7 Ultimate x64 | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows Vista | 9.22_M2 | 9.2 TS2M2 | ||||
| Windows Vista for x64 | 9.22_M2 | 9.2 TS2M2 | ||||
| 64-bit Enabled AIX | 9.22_M2 | 9.2 TS2M2 | ||||
| 64-bit Enabled HP-UX | 9.22_M2 | 9.2 TS2M2 | ||||
| 64-bit Enabled Solaris | 9.22_M2 | 9.2 TS2M2 | ||||
| HP-UX IPF | 9.22_M2 | 9.2 TS2M2 | ||||
| Linux | 9.22_M2 | 9.2 TS2M2 | ||||
| Linux for x64 | 9.22_M2 | 9.2 TS2M2 | ||||