JR45623: JDBC DOESN'T REPORT SQLCODE 100 WHEN NO DATA IS UPDATED OR DELETED

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

APAR status

• Closed as program error.

Error description

• 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
  

Local fix

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

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who use Federation Server JDBC wrapper                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Federation Server V9.7.0.9                        *
  ****************************************************************
  

Problem conclusion

• With the fix, Customer can receive a warning with SQLSTATE 100.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  JR46425 IC95436

Fix information

• Fixed component name

  FEDSRVR JDBC WR

• Fixed component ID

  5724N9714

Applicable component levels

• R970 PSN

     UP

• R970 PSY

     UP

• RA10 PSN

     UP

• RA10 PSY

     UP