Feedback
The following table lists the default reverse data type mappings for DB2® for z/OS® data sources.
| Federated Typename | Federated Lower Len | Federated Upper Len | Federated Lower Scale | Federated Upper Scale | Federated Bit Data | Federated Data Operators | Remote Typename | Remote Length | Remote Scale | Remote Bit Data |
|---|---|---|---|---|---|---|---|---|---|---|
| BIGINT | 0 | 8 | 0 | 0 | " " | "/0" | BIGINT | 0 | 0 | N |
| BLOB | - | - | - | - | - | - | BLOB | - | - | - |
| CHARACTER | - | - | - | - | - | - | CHAR | - | - | N |
| CHARACTER | - | - | - | - | Y | - | CHAR | - | - | Y |
| CLOB | - | - | - | - | - | - | CLOB | - | - | - |
| DATE | - | 4 | - | - | - | - | DATE | - | - | - |
| DBCLOB | - | - | - | - | - | - | DBCLOB | - | - | - |
| DECIMAL | - | - | - | - | - | - | DECIMAL | - | - | - |
| DOUBLE | - | 8 | - | - | - | - | DOUBLE | - | - | – |
| FLOAT | - | 8 | - | - | - | - | DOUBLE | - | - | - |
| GRAPHIC | - | - | - | - | - | - | GRAPHIC | - | - | N |
| INTEGER | - | 4 | - | - | - | - | INTEGER | - | - | - |
| REAL | - | 4 | - | - | - | - | REAL | - | - | - |
| SMALLINT | - | 2 | - | - | - | - | SMALLINT | - | - | - |
| TIME | - | 3 | - | - | - | - | TIME | - | - | - |
| TIMESTAMP(p) | - | - | p | p | - | - | TIMESTAMP | - | - | - |
| VARCHAR | - | - | - | - | - | - | VARCHAR | - | - | N |
| VARCHAR | - | - | - | - | Y | - | VARCHAR | - | - | Y |
| VARGRAPHIC | - | - | - | - | - | - | VARGRAPHIC | - | - | N |