When you create a map of a database table, a database view, or a stored procedure result set, Information Object Designer assigns an Actuate SQL data type to each column in the map. For example, Figure 10-1 shows the output columns for a map of a SQL Server database table and the Actuate SQL data types for each column.
|
Figure 10-1
|
|
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 10-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.
Table 10-1 lists the generic SQL types supported by the Integration service.
|
Generic SQL type
|
Actuate SQL type
|
||
|
Floating point that can vary between single and double binary precision, depending on the value of size.
|
|||
|
Floating point (double binary precision).
|
|||
|
Decimal with scale decimals, and precision that cannot exceed size.
|
|||
|
Fixed-width character, maximum length is specified by size.
|
|||
|
Variable-width character, maximum length is specified by size.
|
|||
|
LONG
VARCHAR |
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.
|
||
|
Date with time component, with or without fractions-of-a-second field, containing up to 3 digits.
|
