Numeric values are converted as appropriate for the receiving field, provided the value can assume the requested format without losing leading digits.
These types are valid:
- DECIMAL
- NUMERIC
- FLOAT
- REAL
- DOUBLE PRECISION
- BYTEINT
- SMALLINT
- INTEGER
The SQLCODE field in the SQLCA is set to -304 if the host variable cannot contain the returned data.