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 7‑1 shows how DB2 data types map to Actuate SQL data types.
Table 7‑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.