Decimal support environment variable in DataStage®

These environment variables support functions for decimal columns.

APT_DECIMAL_INTERM_PRECISION environment variable in DataStage

The APT_DECIMAL_INTERM_PRECISION environment variable specifies the default maximum precision value for any decimal intermediate variables that are required in calculations.

The default value for the APT_DECIMAL_INTERM_PRECISION environment variable is 38.

APT_DECIMAL_INTERM_SCALE environment variable in DataStage

The APT_DECIMAL_INTERM_SCALE environment variable specifies the default scale value for any decimal intermediate variables that are required in calculations.

The default value for the APT_DECIMAL_INTERM_SCALE environment variable is 10.

APT_DECIMAL_INTERM_ROUND_MODE environment variable in DataStage

APT_DECIMAL_INTERM_ROUND_MODE specifies the default rounding mode for any decimal intermediate variables required in calculations. Its default value is “round_inf”. This variable has a List type. You can use the following values to set this variable:
  • "ceil"
  • "floor"
  • "round_inf"
  • "trunc_zero"