DSNH385I ASSIGNMENT TO AN SQLSTATE OR SQLCODE VARIABLE IN AN SQL PROCEDURE `routine-name` MAY BE OVER-WRITTEN AND DOES NOT ACTIVATE ANY HANDLER

Explanation
  SQL routine routine-name was
created, but it contains an assignment statement that specifies the
SQLCODE or SQLSTATE variable as the target. Assignment to an SQLSTATE
or SQLCODE variable in an SQL routine only changes the value in the
variable, and does not activate any handler. The SQLSTATE and SQLCODE
variables are assigned values by processing of SQL statements in the
SQL routine. Therefore, any value assigned might be over-written as
a result of SQL statement processing.

System action
  The routine definition is processed
successfully.

Programmer response
  No recovery
is necessary. If the intent was to signal an error or warning, specify
the SIGNAL or RESIGNAL statement instead of the assignment. To prevent
this warning, remove any assignments to the SQLSTATE or SQLCODE special
variables.

Severity
   4 (warning)

DSNH385I ASSIGNMENT TO AN SQLSTATE OR SQLCODE VARIABLE IN AN SQL PROCEDURE routine-name MAY BE OVER-WRITTEN AND DOES NOT ACTIVATE ANY HANDLER

Explanation

System action

Programmer response

Severity

DSNH385I ASSIGNMENT TO AN SQLSTATE OR SQLCODE VARIABLE IN AN SQL PROCEDURE `routine-name` MAY BE OVER-WRITTEN AND DOES NOT ACTIVATE ANY HANDLER