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 |