|
Access Data Type |
Equivalent DB2 Type(s) |
Suggested Default |
|
AutoNumber |
INTEGER |
Yes |
|
|
BIG INTEGER |
No |
|
|
DECIMAL |
No |
|
|
SMALLINT |
No |
|
Binary |
VARCHAR (length) FOR BIT DATA |
Yes |
|
|
CHAR (length) FOR BIT DATA |
No |
|
Byte |
SMALLINT |
Yes |
|
|
DECIMAL (3,0) |
No |
|
Currency |
DOUBLE |
Yes |
|
|
DECIMAL (precision, scale) |
DECIMAL(15,2) |
|
Date/Time |
DATE |
Yes |
|
|
TIMESTAMP |
No |
|
|
TIME |
No |
|
Double |
DOUBLE |
Yes |
|
|
BIGINT |
No |
|
Hyperlink |
LONG VARCHAR |
Yes |
|
|
DATALINK |
|
|
Integer |
SMALLINT |
Yes |
|
Long |
INTEGER |
Yes |
|
Memo |
LONG VARCHAR |
Yes |
|
|
CLOB (length) |
No |
|
|
VARCHAR (length) |
No |
|
OLE Object |
BLOB (length) |
Yes |
|
|
LONG VARCHAR FOR BIT DATA |
No |
|
Single |
REAL |
Yes |
|
|
DOUBLE |
No |
|
|
BIGINT |
No |
|
Text |
VARCHAR (length) |
Yes |
|
|
CHAR (length) |
No |
|
Yes/No |
SMALLINT |
Yes |
|
|
DECIMAL (1,0) |
No |
|
Lookup Wizard |
NOT SUPPORTED |
|