|
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 LDM, 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
|
Variable Character
|
String values of a variable length up to the given maximum length
|
Single Character
|
A single character value
|
Text
|
A virtually unlimited length string value, actual maximum length depending on implementation
|
BLOB
|
A virtually unlimited length binary value, actual maximum length depending on implementation
|
|