DB2 FOR LUW / DB2FORLUW / 970 - DB2

When generated keys is specified in a prepared statement, and 
useIdentityValLocalForAutoGeneratedKeys property is set to 
'false' or not set, JCC generates a SELECT FROM INSERT 
query to retrieve generated keys. 
 
However, the query generator is not checking if the column name 
is case sensitive (it should be within quotes if it is) and 
using the column name without quotes results in an invalid 
column SQL exception.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade JDBC driver to the one included with v9.7 Fixpack 5. * 
****************************************************************

Set useIdentityValLocalForAutoGeneratedKeys=true

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in the JDBC driver included with v9.7 
Fixpack 5.  This is a client side fix.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC79655 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

21.07.2011
04.07.2012
04.07.2012

9.7.,
9.7.FP5