The source is DB2 and the target is Oracle, the following restrictions and
conversions are performed:
Table 36. Data Type Conversion: DB2 to Oracle
| DB2 for OS/390 Source data type | Oracle Target data type | Changes after Create Nickname | ||
|---|---|---|---|---|
| COLTYPE | LENGTH | SCALE | ||
| FOR BIT DATA(n) | RAW(n) |
|
|
|
| CHAR (<256) | CHAR(n) |
|
|
|
| CHAR (>=256) VARCHAR2(n) | VARCHAR2(n) |
|
|
|
| VARCHAR(n) | VARCHAR2(n) |
|
|
|
| GRAPHIC(n) | CHAR(n) |
|
|
|
| VARGRAPHIC(n) | VARCHAR(n) |
|
|
|
| LONG VARCHAR | LONG |
|
|
|
| DATE | DATE | DATE | 4 |
|
| TIMESTAMP | DATE |
|
|
|
| TIME | DATE | TIME | 3 |
|
| SMALLINT | NUMBER(5) | DECIMAL | 5 | 0 |
| INTEGER | NUMBER(10) | DECIMAL | 10 | 0 |
| DECIMAL(n,m) | DECIMAL(n,m) | DECIMAL | n | m |
| FLOAT | FLOAT |
|
|
|