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

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: