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.
Default data types for dynamically-created tables
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.