The following classes of data and associated data types are supported. These data classes are important for data compatibility when you specify column values in relationships and Column Maps.
DBMS | Data Types |
---|---|
DB2® | CHAR, VARCHAR, CLOB |
Oracle | CHAR, VARCHAR2, LONG, CLOB, NCLOB, NCHAR, NVARCHAR |
Sybase ASE | CHAR, VARCHAR, TXT |
SQL Server | CHAR, VARCHAR, TXT |
Informix® | CHAR, VARCHAR, TXT |
DBMS | Data Types |
---|---|
DB2 | INTEGER, SMALLINT, DECIMAL, FLOAT, DOUBLE |
Oracle | NUMBER, FLOAT |
Sybase ASE | TINYINT, INT, SMALLINT, DECIMAL, FLOAT, REAL, MONEY, SMALL MONEY |
SQL Server | TINYINT, INT, SMALLINT, DECIMAL, FLOAT, REAL, MONEY, SMALL MONEY |
Informix | INTEGER, SMALLINT, DECIMAL, FLOAT, REAL, DOUBLE PRECISION, SMALLFLOAT, SERIAL, MONEY, NUMERIC |
DBMS | Data Types |
---|---|
DB2 | CHAR (for Bit Data), VARCHAR (for Bit Data), BLOB |
Oracle | RAW, LONG RAW |
Sybase ASE | BINARY, VARBINARY, IMAGE |
SQL Server | BINARY, VARBINARY, IMAGE |
Informix | BYTE |
DBMS | Data Types |
---|---|
Sybase ASE | BOOLEAN (TRUE or FALSE) |
DBMS | Data Types |
---|---|
DB2 | TIMESTAMP |
Oracle | DATE, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE |
Sybase ASE | DATETIME, SMALL DATE TIME |
SQL Server | DATETIME, SMALL DATE TIME |
Informix | DATE, DATETIME |
DBMS | Data Types |
---|---|
DB2 | DATE |
Oracle | DATE |
Informix | DATE |
DBMS | Data Types |
---|---|
DB2 | TIME |
DBMS | Data Types |
---|---|
Oracle | YEAR/MONTH INTERVAL, DAY/SECOND INTERVAL |
Informix | YEAR/MONTH INTERVAL, DAY/TIME INTERVAL |