-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