DB2 FOR LUW / DB2FORLUW / A50 - DB2

JDBC wrapper doesn't report SQLCODE +100 when no data is 
updated or deleted. This because the JDBC driver doesn't 
report any warning when NO data is updated or deleted. 
 
For example: 
 
db2 =>  SELECT * FROM N1 
 
c1          c2 
----------- ---------- 
          1 3343 
          2 123 
 
  2 record(s) selected. 
 
db2 => UPDATE N1 SET "c1" = '123' where "c1"=3 
DB20000I  The SQL command completed successfully. 
 
The expected result is: 
SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the 
result of a 
query is an empty table.  SQLSTATE=02000

User affected: 
  Users who use JDBC wrapper of  InfoSphere Federation Server 
Problem description and summay: 
  See error description

Please contact the vendor of JDBC driver and make sure there is 
SQLWarning with SQLSTATE 100 reported after executing the SQL.

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem was fistly fixed in Version 10.5 FixPak 3. This 
fix should be applied on the federation Server.

keiner bekannt / siehe Local-Fix

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

27.08.2013
10.03.2014
10.03.2014