This section shows default mappings between DB2 data types supported by the federated server and data type supported by the following data sources:
The mappings shown are between non-identical data types. Mappings between identical data types are not shown.
| DB2 for MVS, DB2 for OS/390 | DB2 |
|---|---|
| varchar(n), n <= 32672 | varchar(n) |
| vargraphic(n), n <= 16336 | vargraphic(n) |
| char(255) | varchar(255) |
| char(255) for bit data | varchar(255) for bit data |
| DB2 for OS/400, DB2 for AS/400 | DB2 |
|---|---|
| char(n), n <= 254 | char(n) |
| char(n), n between 255 and 32672 | varchar(n) |
| varchar(n), n <= 32672 | varchar(n) |
| graphic(n), n <= 127 | graphic(n) |
| graphic(n), n between 127 and 16336 | vargraphic(n) |
| vargraphic(n), n <= 16336 | vargraphic(n) |
Table 110. Default Type Mappings between DB2 and Oracle Data Sources
| Oracle | DB2 |
|---|---|
| rowid | char(18) |
| char(n), n <= 254 | char(n) |
| nchar(n), n <= 254 | char(n) |
| char(255) | varchar(255) |
| varchar2(n), n <= 32672 | varchar(n) |
| nvarchar2(n), n <= 32672 | varchar(n) |
| number(p,s), p <= 4 and s = 0 | smallint |
| number(p,s), 4 <= p <= 9 and s = 0 | integer |
| number(p,s), 10 <= p <= 18 and s = 0 | bigint |
| number(p,s), p <= 31 and 0 <= s <= p and previous two cases don't match | decimal |
| number(p,s), all cases other than the previous 4 | double |
| raw(n), n <= 254 | char(n) for bit data |
| raw(255) | varchar(255) for bit data |
| date (char(9)) | timestamp |
Table 111. Default Type Mappings between DB2 and DB2 for VM and VSE (and SQL/DS) Data Sources
| DB2 for OS/390, SQL/DS | DB2 |
|---|---|
| varchar(n), n <= 32672 | varchar(n) |
| vargraphic(n), n <= 16336 | vargraphic(n) |