A list of all supported data types in business measures models, their sizes, and the corresponding data type name in both Java™ and DB2®.
Business Measures ModelTypes | Size | Java Type used | DB2 8 for Linux®, UNIX® and Windows® |
---|---|---|---|
Boolean | 1 Bit | boolean | SMALLINT |
String with "IsInternational" descriptor | length in chars | String | VARCHAR Length or (Length * 3) |
Date | 8 Bytes | long | BIGINT |
Time | 8 Bytes | long | BIGINT |
DateTime | 8 Bytes | long | BIGINT |
Duration | 8 Bytes | long | BIGINT |
Long | 8 Bytes | long | BIGINT |
Integer | 4 Bytes | int | INTEGER |
Short | 2 Bytes | short | SMALLINT |
Byte | 1 Byte | byte | SMALLINT |
Double | Approx. in 64 Bits | double | DOUBLE |
Float | Approx in 32 Bits | float | REAL |