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