| SQL Server data type |
IBM DB2 AS400 ODBC |
IBM DB2 MVS ODBC |
|||
|---|---|---|---|---|---|
| binary(n) | L | S | |||
| bit | S | S | |||
| char(n) | S | S | |||
| datetime | S** | S** | |||
| decimal | S | S | |||
| float | S | L | |||
| image | N | N | |||
| int | S | S | |||
| money | S | S | |||
| nchar(n) | S | S | |||
| ntext | N | N | |||
| numeric | S | S | |||
| nvarchar(n) | S | S | |||
| real | S | S | |||
| smalldatetime | S | S | |||
| smallint | S | S | |||
| smallmoney | S | S | |||
| text | S | N | |||
| timestamp | S | S | |||
| tinyint | S | S | |||
| uniqueidentifier | S | S | |||
| varbinary(n) | S | S | |||
| varchar(n) | S | S | |||
| S = supported | L = limited support | N = not supported | |||
| S** See DTS Data Conversion and Transformation Considerations | |||||
