db2 ? sql0471n


SQL0471N Invocation of routine "<name>" failed due to reason
"<reason-code>".

Explanation:

The invocation of routine "<name>" failed. Use reason code
"<reason-code>" to find out more details about the cause of the failure.

User response:

If the reason code starts with "DSNX9":
* The routine was invoked on a DB2 Universal Database for z/OS server.
A DSNX9xx message describing the error might be displayed on the
server's system console. Consult the documentation for the DB2 UDB
for z/OS server and correct the condition described by the reason
code.

Else, the following lists the action to take for the indicated reason
code:

1 The invocation failed because the SQL routine was created on a
previous release of the product and the DBMS was not able to
migrate it to the current release. The routine must be dropped
and re-created to become operative again.

sqlcode: -471

sqlstate: 55023