Start of change

-5012   HOST VARIABLE host-variable IS NOT EXACT NUMERIC WITH SCALE ZERO

Explanation

A host variable was specified in one of the following statements, but it is not valid in the context in which it was used.

  • In a FETCH statement, as part of an ABSOLUTE or RELATIVE position definition
  • In a MERGE, FETCH, or INSERT statement, as part of a ROWS clause
host-variable
The name of the host variable.

The host variable was not usable for one of the following reasons:

  • It is not an exact numeric type.
  • The scale is not zero.

System action

The statement cannot be processed.

Programmer response

Change the host variable to be an exact numeric with a scale of zero.

SQLSTATE

42618

End of change