Default data types for dynamically created tables
For each supported database that the
Interact
runtime system uses, there are hardcoded data types used by default 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 2014. All Rights Reserved.