Integers, UNSIGNED |
The DB2 integer that holds the range. An UNSIGNED column takes the next size up; BIGINT UNSIGNED becomes DECIMAL(20). |
BIT(n) |
Its number: SMALLINT, INTEGER or BIGINT by width, and DECIMAL(20) for BIT(64). Every value arrives whole. |
DECIMAL |
DECIMAL up to 31 digits. Wider ones become DECFLOAT(34), which holds 34 digits exactly. |
DATETIME, TIMESTAMP, TIME |
TIMESTAMP(n) with the same fraction digits. DB2 TIME keeps whole seconds within a day: a fraction, a time past 24 hours or a negative time is refused and named in the log. |
VARCHAR, CHAR, ENUM, SET |
VARCHAR and CHAR, sized in characters; longer text becomes CLOB. ENUM and SET become VARCHAR. |
Indexes, AUTO_INCREMENT |
Index names get the table name in front, since DB2 names indexes per schema. FULLTEXT indexes are not created. AUTO_INCREMENT becomes an identity that continues after the copied rows. |