Default forward data type mappings for Db2 for IBM i data sources
The following table lists the default forward data type mappings for Db2 for IBM i data sources.
| Remote Typename | Remote Lower Len | Remote Upper Len | Remote Lower Scale | Remote Upper Scale | Remote Bit Data | Remote Data Operators | Federated Typename | Federated Length | Federated Scale | Federated Bit Data |
|---|---|---|---|---|---|---|---|---|---|---|
| BLOB | - | - | - | - | - | - | BLOB | - | - | - |
| CHAR | 1 | 254 | - | - | - | - | CHAR | - | 0 | N |
| CHAR | 255 | 32672 | - | - | - | - | VARCHAR | - | 0 | N |
| CHAR | 1 | 254 | - | - | Y | - | CHAR | - | 0 | Y |
| CHAR | 255 | 32672 | - | - | Y | - | VARCHAR | - | 0 | Y |
| CLOB | - | - | - | - | - | - | CLOB | - | - | - |
| DATE | - | - | - | - | - | - | DATE | - | 0 | - |
| DBCLOB | - | - | - | - | - | - | DBCLOB | - | - | - |
| DECIMAL | - | - | - | - | - | - | DECIMAL | - | - | - |
| FLOAT | 4 | - | - | - | - | - | REAL | - | - | - |
| FLOAT | 8 | - | - | - | - | - | DOUBLE | - | - | - |
| GRAPHIC | 1 | 127 | - | - | - | - | GRAPHIC | - | 0 | N |
| GRAPHIC | 128 | 16336 | - | - | - | - | VARGRAPHIC | - | 0 | N |
| INTEGER | - | - | - | - | - | - | INTEGER | - | 0 | - |
| NUMERIC | - | - | - | - | - | - | DECIMAL | - | - | - |
| SMALLINT | - | - | - | - | - | - | SMALLINT | - | 0 | - |
| TIME | - | - | - | - | - | - | TIME | - | 0 | - |
| TIMESTAMP | - | - | - | - | - | - | TIMESTAMP(6) | - | 6 | - |
| VARCHAR | 1 | 32672 | - | - | - | - | VARCHAR | - | 0 | N |
| VARCHAR | 1 | 32672 | - | - | Y | - | VARCHAR | - | 0 | Y |
| VARG | 1 | 16336 | - | - | - | - | VARGRAPHIC | - | 0 | N |
| VARGRAPHIC | 1 | 16336 | - | - | - | - | VARGRAPHIC | - | 0 | N |