Fixes are available
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 number
JR45623
Reported component name
FEDSRVR JDBC WR
Reported component ID
5724N9714
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-02-03
Closed date
2013-12-16
Last modified date
2013-12-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]
Document Information
Modified date:
07 October 2021