Exact numeric data types (DECIMAL and NUMERIC) can hold values up to a driver-specified precision and scale.
Host Variable Formats
-
OpenESQL and DB2 ECM
-
01 packed1 PIC S9(8)V9(10) USAGE COMP-3.
01 packed2 PIC S9(8)V9(10) USAGE PACKED-DECIMAL.
01 packed3 PIC S9(8)v9(10) USAGE DISPLAY.
Both OpenESQL and DB2 ECM support:
- Unsigned and signed DISPLAY numerics
- Leading and trailing signs
- OpenESQL JVM Managed Runtime
- In addition to the definitions valid for OpenESQL, the following definition is also valid for the OpenESQL JVM Managed Runtime:
01 packed05 type java.math.BigDecimal.