-20314 THE PARAMETER LIST (OR AN OPTION) DOES NOT MATCH THE PARAMETER LIST (OR OPTION) FOR ALL OTHER VERSIONS OF ROUTINE routine-name
Explanation
An inconsistency exists between the parameters for the currently active version of the routine and other versions of the routine. This error can be issued for any of the following reasons:
- The number of parameters, data types, CCSID specifications, and character data attributes (FOR BIT, SBCS, or MIXED DATA) in the parameter list must be the same as the attributes of the corresponding parameters of the currently active version of the routine and all of the other existing versions of the routine.
- The data type, CCSID specification, and character data attributes (FOR BIT, SBCS, or MIXED DATA) for the RETURNS parameter must be the same as the attributes of the RETURNS parameter of the currently active version of the routine and all of the other existing versions of the routine.
- An ALTER PROCEDURE statement was specified with the PARAMETER CCSID clause with a value that is different from the value determined when the procedure was initially created.
System action
The statement cannot be processed.
User response
Correct the specification of the parameter list or RETURNS clause, or change or remove the PARAMETER CCSID clause.
SQLSTATE
428GH
