DSNT414I   SQLERRM = xxxx, SQLCA ERROR MESSAGE INSERTION TEXT

Explanation

This message results from an SQL return code that is not recognized by DSNTIAR. SQLERRM contains error message text.

System programmer response

Either the SQLCA area is invalid or the maintenance was not coordinated correctly. As a result, the SQL return code was added to the DB2® subsystem but not to the formatting routine.

An invalid SQLCA area is usually the result of one of the following:
  • Calling the DSNTIAR formatting routine before an SQL statement initializes the area
  • Overlaying the SQLCA area
  • Passing the wrong address to the DSNTIAR routine.

If the maintenance was not coordinated correctly, the DSNTIAR and DSNTIAM CSECTs were probably not replaced in the code that is now running. Link-edit the load module, and replace DSNTIAR and DSNTIAM. Correct the error, and rerun the application program.