Default reverse data type mappings for JDBC data sources
The following table lists the default reverse data type mappings for JDBC data sources that conform to the type mappings of the Db2® JDBC driver.
| 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 | - | - | - | - | - | - | BIGINT | - | - | - |
| BLOB | - | - | - | - | - | - | BLOB | - | - | - |
| CHAR | - | - | - | - | Y | - | BINARY | - | - | - |
| CHAR | - | - | - | - | - | - | CHAR | - | - | - |
| CLOB | - | - | - | - | - | - | CLOB | - | - | - |
| DATE | - | 4 | - | - | - | - | DATE | - | - | - |
| DBCLOB | - | - | - | - | - | - | NCLOB | - | - | - |
| DECIMAL | - | - | - | - | - | - | DECIMAL | - | - | - |
| DOUBLE | - | 8 | - | - | - | - | DOUBLE | - | - | - |
| GRAPHIC | - | - | - | - | - | - | NCHAR | - | - | - |
| INTEGER | - | - | - | - | - | - | INTEGER | - | - | - |
| REAL | - | 4 | - | - | - | - | REAL | - | - | - |
| SMALLINT | - | - | - | - | - | - | SMALLINT | - | - | - |
| TIME | - | 3 | - | - | - | - | TIME | - | - | - |
| TIMESTAMP | - | - | - | - | - | - | TIMESTAMP | - | - | - |
| TIMESTAMP(p) | - | - | p | p | - | - | TIMESTAMP(p) | - | min(9,p) | - |
| VARCHAR | - | - | - | - | Y | - | VARBINARY | - | - | - |
| VARCHAR | - | - | - | - | N | - | VARCHAR | - | - | - |
| VARGRAPHIC | - | - | - | - | - | - | NVARCHAR | - | - | - |