Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Signed fields are exact, fixed-point numeric fields with a precision (# of significant digits), and a scale (# of digits after decimal place). The scale may be 0, indicating a whole number. Signed fields store signed numbers (+/-).

Please review the general 1.1.1 Field Type Considerations.

...

  • Refer to Platform Considerations in 1.1.1 Field Type Considerations.
  • Oracle and SQL Server support a maximum of 38 digits of which up to 38 may be decimals. You may use fields with a larger definition, but if these fields are on a file, the column will be created with a smaller size. For example, Packed(63,9) will be created as (38,9). If the field has more than 38 significant digits and you try to write it to the database, an error will occur.

Also See

1.1.7 Packed

1.1.9 Integer

1.1.10 Float