DB2 Data Types to OutSystems Data Types

When importing entities from the databases, OutSystems Platform maps DB2 Server data types into OutSystems data types.

The map between the data types is specified in the following table:

DB2 Server data Types	OutSystems data types
BIGINT	Long Integer
BINARY	Binary Data
BLOB	Binary Data
CHAR	Text
CHAR, BIT data subtype	Binary Data
CLOB	Text
DATALINK	Text
DATE	Date
DBCLOB	Text
DECFLOAT	if the precision is lower than 38 -> Decimal; otherwise -> Text
DECIMAL	Decimal
DOUBLE	if the precision is lower than 38 -> Decimal; otherwise Text
GRAPHIC	Text
INTEGER	if the precision is 1 -> Boolean; otherwise -> Integer
NCHAR	Text
NCLOB	Text
NUMERIC	Decimal
NVARCHAR	Text
REAL	if the precision is lower than 38 -> Decimal; otherwise -> Text
SMALLINT	if the precision is 1 -> Boolean; otherwise -> Integer
TIME	Time
TIMESTAMP	Date Time
VARBINARY	Binary Data
VARCHAR	Text
VARCHAR, Bit data subtype	Binary Data
VARGRAP	Text
XML	Text
All other data types	Unsupported*

*All the other unsupported DB2 data types will be created without assigning data type. The developer need to map them manually with the OutSystems data types.