DSNH4773I W csect-name LINE line-number COL column-number HANDLER BODY IS A CONTROL STATEMENT OTHER THAN A COMPOUND STATEMENT

Explanation

The body of a handler declaration is an SQL control statement other than an SQL compound statement.

csect-name
The name of the control section that issued the message.
line-number and column-number
The location of the error in the source program.

This usage causes the original condition information available to the condition handler logic to be displaced in the following manner:

  • The SQL diagnostic area accessed by a GET CURRENT DIAGNOSTICS statement will be modified and unrelated to the original condition.
  • The values of variables SQLSTATE and SQLCODE will be modified and unrelated to the original condition.

System action

Processing continues.

User response

Replace the SQL control statement (IF, CASE, LOOP, REPEAT, WHILE) that defines the body of the handler declaration with an SQL compound statement (BEGIN).

Severity

4 (warning)