Compatibility Rules for Column Maps

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.

Character
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
Note: Single-byte character columns are not compatible with multi-byte or Unicode character columns.
Numeric
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
Binary
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
Boolean
DBMS Data Types
Sybase ASE BOOLEAN (TRUE or FALSE)
Datetime
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
Date
DBMS Data Types
DB2 DATE
Oracle DATE
Informix DATE
Time
DBMS Data Types
DB2 TIME
Interval
DBMS Data Types
Oracle YEAR/MONTH INTERVAL, DAY/SECOND INTERVAL
Informix YEAR/MONTH INTERVAL, DAY/TIME INTERVAL