About data type mapping
When you create a map of a database table, a database view, or a stored procedure result set, the IO Design perspective assigns an Actuate SQL data type to each column in the map. For example, Figure 9‑1 shows the output columns for a map of a SQL Server database table and the Actuate SQL data types for each column.
Figure 9‑1 Output columns and Actuate SQL data types for a map of a database table
The Actuate SQL data type for a column is determined as follows:
*The JDBC driver provides the generic SQL data type for the column, for example INTEGER, FLOAT, VARCHAR, or DATE.
*Based on the generic SQL data type, the Integration service chooses the best Actuate SQL data type for the column.
For example, in Figure 9‑2 a column in a SQL Server database table has FLOAT data type. The JDBC driver provides the generic SQL data type FLOAT. The Integration service then chooses the Actuate SQL data type DOUBLE.
Figure 9‑2 Mapping a database data type to an Actuate SQL data type
Table 9‑1 lists the generic SQL types supported by the Integration service.
Table 9‑1 Generic SQL types supported by the Integration service
Generic SQL type
Facets
Description
Actuate SQL type
BIT
 
1-bit integer, with value 1 or 0.
INTEGER
TINYINT
 
8-bit integer.
INTEGER
SMALLINT
 
16-bit integer.
INTEGER
INTEGER
 
32-bit integer.
INTEGER
BIGINT
 
64-bit integer.
DECIMAL
FLOAT
Size
Floating point that can vary between single and double binary precision, depending on the value of size.
DOUBLE
REAL
 
Floating point (single binary precision).
DOUBLE
DOUBLE
 
Floating point (double binary precision).
DOUBLE
NUMERIC
Size, decimals
Decimal with scale decimals, and precision that cannot exceed size.
DECIMAL
DECIMAL
Size, decimals
Same as NUMERIC.
DECIMAL
CHAR
Size
Fixed-width character, maximum length is specified by size.
VARCHAR
VARCHAR
Size
Variable-width character, maximum length is specified by size.
VARCHAR
LONGVARCHAR
Size
Long variable-width character. Maximum length is specified by size. The Integration service does not support strings with a maximum length of more than 64,000 characters.
VARCHAR
DATE
 
Date with no time component.
TIMESTAMP
TIMESTAMP
 
Date with time component, with or without fractions-of-a-second field, containing up to 3 digits.
TIMESTAMP