Default forward data type mappings for Db2 for VM and VSE data sources
The following table lists the default forward data type mappings for Db2 for VM and VSE 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 | 1 | 254 | - | - | Y | - | CHAR | - | 0 | Y |
CLOB | - | - | - | - | - | - | CLOB | - | - | - |
DATE | - | - | - | - | - | - | DATE | - | 0 | - |
DBAHW | - | - | - | - | - | - | SMALLINT | - | 0 | - |
DBAINT | - | - | - | - | - | - | INTEGER | - | 0 | - |
DBCLOB | - | - | - | - | - | - | DBCLOB | - | - | - |
DECIMAL | - | - | - | - | - | - | DECIMAL | - | - | - |
FLOAT | 4 | - | - | - | - | - | REAL | - | - | - |
FLOAT | 8 | - | - | - | - | - | DOUBLE | - | - | - |
GRAPHIC | 1 | 127 | - | - | - | - | GRAPHIC | - | 0 | N |
INTEGER | - | - | - | - | - | - | INTEGER | - | - | - |
SMALLINT | - | - | - | - | - | - | SMALLINT | - | - | - |
TIME | - | - | - | - | - | - | TIME | - | 0 | - |
TIMESTAMP | - | - | - | - | - | - | TIMESTAMP(6) | - | 6 | - |
VARCHAR | 1 | 32672 | - | - | - | - | VARCHAR | - | 0 | N |
VARCHAR | 1 | 32672 | - | - | Y | - | VARCHAR | - | 0 | Y |
VARGRAPHIC | 1 | 16336 | - | - | - | - | VARGRAPHIC | - | 0 | N |
VARGRAPH | 1 | 16336 | - | - | - | - | VARGRAPHIC | - | 0 | N |