This is an old revision of the document!
Technical information on migration from Microsoft SQL Server to IBM DB2.
Last Update: Microsoft SQL Server 2012 and IBM DB2 10.1
Converting data types:
SQL Server | IBM DB2 | |
CHAR | Fixed-length character string | CHAR |
INT, INTEGER | 32-bit integer | INT, INTEGER |
SMALLINT | 16-bit integer | SMALLINT |
VARCHAR | Variable-length character string | VARCHAR |