Passing numeric data

Edit online

The following considerations exist for passing numeric data with a CMI:

  • Packed Decimal Fields. If a field is defined as Packed Decimal in the ACI input map, the following guidelines apply:
    • If the value passed has a scale that is too long, the size of the scale in the ACI input map is used. The IBM Data Virtualization Manager for z/OS Interface for ACI allows the value if the adjusted precision is less than or equal to the precision in the ACI input map, and the scale is truncated.
    • Although the IBM Data Virtualization Manager for z/OS Interface for ACI allows you to pass a string to a Packed Decimal field, it does not allow the decimal point to be specified in the string (the decimal is based on what is defined in the ACI input map). Also, if the length of the string exceeds the precision of the field, the leading digits in the string are truncated. For these reasons, it is not recommended to pass a string value to a packed field.
  • SmallInt Fields. The IBM Data Virtualization Manager for z/OS Interface for ACI allows a value that is passed as an integer to a field defined in the ACI input map as SmallInt. Ensure that the value is less than or equal to 32767. Otherwise, the data is truncated.