Disable Decimal Padding

DisableDecimalPadding

This option specifies whether to disable decimal padding.

  • Enabled (1)1: The connector disables decimal padding, and fits the decimal scale to the input parameter's scale, on a per-row basis.
    • Trailing zeroes are discarded. For example, 1.500 is inserted as 1.5.
    • Values with a scale that is greater than the default column scale are truncated. For example, if the default column scale is 3 and the value is 1.5557, the value is inserted as 1.555.
  • Disabled (0)0: The connector uses decimal padding.

To set the default decimal column scale, see Default Column Scale.

Key Name Default Value Required

DisableDecimalPadding

Clear (0)0

No