Problem:
If an embedded SQL statement is returning sqlcode < 0, "SQLERRM" does not contain the associated error message. Programs are running in MFE 3.1 using XDB Link to IBM DB2 V8.
This can be reproduced by an invalid referential integrity while updating a table record.
Resolution:
The cause of this failure is the IBM DB2 compatibility mode.
SQLERRM is filled as expected in the IBM DB2 new function mode.
Old KB# 2644
#EnterpriseDeveloper
#MFDS
