Fixes are available
APAR status
Closed as Vendor Solution.
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
Problem conclusion
Temporary fix
Comments
This is due to vendor's driver doesn't support it
APAR Information
APAR number
JR46425
Reported component name
FEDSRVR JDBC WR
Reported component ID
5724N9714
Reported release
A10
Status
CLOSED ISV
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-22
Closed date
2013-10-28
Last modified date
2013-10-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 October 2021