Problem Note 20977: SAS/ACCESS® Interface to DB2 cannot obtain the last inserted identity value unless you issue a separate SELECT statement after the INSERT statement
 |  |  |  |  |
SAS/ACCESS Interface to DB2 cannot obtain the last inserted identity value unless you submit a separate SELECT statement after the INSERT statement.
Select the Hot Fix tab in this note to access the hot fix for this issue.
This hot fix includes the new FETCH_IDENTITY= data set option for the LIBNAME statement. This option accepts a value of either YES or NO value. The default value is NO.
If you set the option to YES and the INSERT statement is executed such that it inserts a single row, the DB2 engine places the results into the macro variable SYSDB2_LAST_IDENTITY.
Note: The default behavior for the DB2 engine is to insert multiple rows. To use FETCH_IDENTITY=YES, you must force the use of single-row insertion by setting the option INSERTBUFF=1.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 | ||