Default data types for dynamically created tables

For each supported database that the Unica Interact runtime system uses, there are hardcoded data types used by default for float, number, date/time, and string columns.

Table 1. Default data types for dynamically-created tables
Database Default data types
DB2®
  • float
  • bigint
  • timestamp
  • varchar
Oracle
  • float
  • number(19)
  • timestamp
  • varchar2
SQL Server
  • float
  • bigint
  • datetime
  • nvarchar