When the source is DB2 and the target is Microsoft Jet, the following
restrictions and conversions are performed:
Table 39. Data Type Conversion: DB2 to Microsoft Jet
| DB2 for OS/390 SOURCE | MS JET TARGET | Changes after Create Nickname | ||
|---|---|---|---|---|
| COLTYPE | LENGTH | SCALE | ||
| CHAR (n) FOR BIT DATA | Memo or OLE Object1 |
|
|
|
| VARCHAR(n) FOR BIT DATA(N) | Memo or OLE Object1 |
|
|
|
| CHAR(n) | Text or Memo1 |
|
|
|
| VARCHAR(<256) | Text or Memo1 |
|
|
|
| GRAPHIC(n) 2 | ? |
|
|
|
| VARGRAPHIC(n) 2 | ? |
|
|
|
| LONG VARCHAR 2 | Memo |
|
|
|
| DATE | Datetime |
|
|
|
| TIMESTAMP | Datetime |
|
|
|
| TIME | Text |
|
|
|
| SMALLINT | Number (Integer) |
|
|
|
| INTEGER | Number (Long Integer) |
|
|
|
| DECIMAL(n,m), NUMERIC | Number (Integer), Number (Long Integer), Number (Double), or Text1 |
|
|
|
| PRECISION, FLOAT, DOUBLE | Number (Double) |
|
|
|
|
1The value used depends on the precision set for the field. 2These DB2 for OS/390 data types have not been tested.
|