DSNT413I SQLCODE = xxxx, INVALID SQLCODE

Explanation

The SQL return code is not a valid value.

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.