Data types

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

Copyright IBM Corporation 2005. All Rights Reserved.