Start of change

DSNT002I   program-name RECEIVED AN UNEXPECTED SQLCODE OF sql-code FROM THE sql-request REQUEST

Explanation

During processing of an SQL request, the program received an unexpected SQL code. Further processing has been halted.

program-name
The name of the program.
sql-code
A numeric value that indicates why the SQL statement execution was unsuccessful.
sql-request
All or part of the SQL statement that was issued. For a long statement, only a portion of the statement is provided.

System action

The program rolls back all SQL changes and terminates.

User response

Examine the standard SQLCA diagnostic messages and output in the SYSPRINT output log at the point of failure to determine the cause of the error. Correct the error and rerun the program.

Problem determination

This message is followed by one or more of the standard SQLCA diagnostic messages: DSNT404I, DSNT408I, DSNT411I, DSNT415I, DSNT416I, DSNT417I, and DSNT418I.

Severity

12 (severe error)

End of change