Default reverse data type mappings for Db2 for VM and VSE data sources
The following table lists the default reverse data type mappings for Db2 for VM and VSE 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| BLOB | - | - | - | - | - | - | BLOB | - | - | - |
| CHARACTER | - | - | - | - | - | - | CHAR | - | - | - |
| CHARACTER | - | - | - | - | Y | - | CHAR | - | - | Y |
| CLOB | - | - | - | - | - | - | CLOB | - | - | - |
| DATE | - | 4 | - | - | - | - | DATE | - | - | - |
| DBCLOB | - | - | - | - | - | - | DBCLOB | - | - | - |
| DECIMAL | - | - | - | - | - | - | DECIMAL | - | - | - |
| DOUBLE | - | 8 | - | - | - | - | FLOAT | - | - | - |
| GRAPHIC | - | - | - | - | - | - | GRAPHIC | - | - | N |
| INTEGER | - | 4 | - | - | - | - | INTEGER | - | - | - |
| REAL | - | 4 | - | - | - | - | REAL | - | - | - |
| SMALLINT | - | 2 | - | - | - | - | SMALLINT | - | - | - |
| TIME | - | 3 | - | - | - | - | TIME | - | - | - |
| TIMESTAMP(p) | - | - | p | p | - | - | TIMESTAMP | - | - | - |
| VARCHAR | - | - | - | - | - | - | VARCHAR | - | - | - |
| VARCHAR | - | - | - | - | Y | - | VARCHAR | - | - | Y |
| VARGRAPH | - | - | - | - | - | - | VARGRAPH | - | - | N |