DB2 data type mapping and issues

The following DB2 functions convert DECIMAL values to the DOUBLE data type. The corresponding Actuate SQL functions are implemented using these native functions, and may therefore return slightly inaccurate values, especially for calculations involving very large or very small numbers:

POWER ( )

ROUND ( )

FLOOR ( )

CEILING ( )

When a numeric type is cast to VARCHAR(n) and n is not large enough to accommodate the string, Actuate SQL returns an error. DB2, however, truncates the value without returning an error.

Table 8-1 shows how DB2 data types map to Actuate SQL data types.

Table 8-1

Mapping of DB2 data types to Actuate SQL data types

DB2 data type	Actuate SQL data type	Compiled to DB2 data type	DB2 data type limitations
BIGINT	DECIMAL	DECIMAL	The maximum number of significant digits (precision) for DB2 DECIMAL is 31.
CHAR	VARCHAR	VARCHAR	DB2 VARCHAR has a maximum length of 32,672 characters.
DATE	TIMESTAMP	DATETIME
DECIMAL	DECIMAL	DECIMAL	The maximum number of significant digits (precision) for DB2 DECIMAL is 31.
DOUBLE	DOUBLE	DOUBLE
INTEGER	INTEGER	INTEGER
REAL	DOUBLE	DOUBLE
SMALLINT	INTEGER	INTEGER
TIMESTAMP	TIMESTAMP	DATETIME
VARCHAR	VARCHAR	VARCHAR	DB2 VARCHAR has a maximum length of 32,672 characters.

Copyright Actuate Corporation 2012