Start of change

-20249   THE PACKAGE package-name NEEDS TO BE REBOUND IN ORDER TO BE SUCCESSFULLY EXECUTED (required-maintenance)

Explanation

A version inconsistency exists between one or more SQL statements in a package and the system that is attempting to process the statement or statements.

package-name
The name of the package that contains the statement or statements.
required-maintenance
An IBM® APAR number that identifies required maintenance, if applicable.

Possible reasons for this message include:

  • The package was bound on a system with an older maintenance level that is no longer supported.
  • The package was bound on a newer maintenance level, but it was sent to execute on a system with an older maintenance level.
  • The package contains a static cursor statement that was bound on a system with an older release than the UPDATE or DELETE WHERE CURRENT OF cursor statement.

System action

The statement cannot be processed.

Programmer response

Take the action that is indicated by the required-maintenance value:

An APAR number
Review the instructions provided with the indicated APAR, and apply the APAR to the data sharing member where the SQL code is issued.
Any other value
Rebind the package on a system with the appropriate maintenance level.

SQLSTATE

560C5

End of change