Default data types for dynamically created tables
The following table lists the hardcoded data types that the Interact runtime system uses by default for each supported database for float, number, date/time and string columns.
Database
Default data types
DB2
float
bigint
timestamp
varchar
Informix
float
int8
DATETIME YEAR TO FRACTION
char2
Oracle
float
number(19)
timestamp
varchar2
SQL Server
float
bigint
datetime
nvarchar
Copyright IBM Corporation 2012. All Rights Reserved.