1.1.7 Packed

Packed 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. Packed fields store signed numbers (+/-).

Please review the general 1.1.1 Field Type Considerations.

Field Definition Rules

Rules for defining a Packed field in the repository are:


Packed fields have a maximum length of 63 in an RDMLX partition and 30 in an RDML partition. Maximum number of decimals is 63 in an RDMLX partition and 9 in an RDML partition.

Valid Keyboard Shift


Allowed Attributes

Null values are not allowed.

Edit Mask

Use of an Edit Mask (that is, an Editcode or Editword) is allowed.




Field Definition Notes

Usage Rules

Partition Type

RDML and RDMLX Partitions.


RDML and RDMLX Files. Packed fields may be used as real fields or  keys.

Logical Views

Packed fields may be used as keys to logical views.

Virtual Fields

Packed fields may be used with Mathematical, Substring, Concatenation or Date Virtual Fields.

Predetermined Join Fields

Packed fields may be used for numeric predetermined joined fields.

Built-In Functions

When used in Built-In Functions, packed fields are valid for arguments of type 'N'.


Refer to Field Type Conversions.


Platform Considerations

Also See

1.1.8 Signed

1.1.9 Integer

1.1.10 Float