Datatypes in a CDM

Value placeholders, like Attributes and Domains, have a "datatypes" assigned. This tells you something about the type of value this placeholder will accept and automatically restricts the possible values.

For example, is the datatype is set to "integer" a value of "ABC" cannot be accepted. On the other hand, if a datatype of "character" is used, both "ABC" and "123" are valid values.

In a CDM, the following datatypes are available for attributes and domains:

Datatype

Description

Short Integer

Smaller integer values, range: -32768..32767

Integer

Normal integer values, range: -2147483648..2147483647

Long Integer

Long integer values, range: -2^63..2^63-1

Byte

Unsigned values, range: 0..255

Unsigned Short Integer

Unsigned values, range 0..65535

Unsigned Integer

Unsigned values, range 0..4294967295

Number

Fixed point decimal values, range depending on Precision and Scale

Float

Floating point values

Money

Fixed point decimal values, range depending on implementation

Date

Date values, range depending on implementation

Time

Time values, range depending on implementation, but usually from 00:00.000 to 23:59.999

Date & Time

Combined Date & Time values, range combined of Date and Time

Character

String values of a fixed length padded with spaces to fill up to the maximum length