Table 216 lists the data type mapping that is performed when the
source data type is a Lotus Domino type.
Table 216. Data type mapping from Lotus Domino source data types
| Domino | DB2 UDB mirror data type | DB2 Everyplace device data type |
|---|---|---|
| CHAR(n) | CHARACTER | CHARACTER |
| DATE | DATE | DATE |
| DECIMAL[(p[,s])] | DECIMAL | DECIMAL |
| DOUBLE PRECISION | DOUBLE | VARCHAR |
| FLOAT(p) | DOUBLE | VARCHAR |
| INTEGER | DOUBLE | VARCHAR |
| LONGVARCHAR | LONGVARCHAR | VARCHAR |
| NUMERIC(p,s) | DECIMAL | DECIMAL |
| REAL | DOUBLE | VARCHAR |
| SMALLINT | SMALLINT | SMALLINT |
| TIME | TIME | TIME |
| TIMESTAMP | TIMESTAMP | TIMESTAMP |
| VARCHAR(n) | VARCHAR | VARCHAR |
| BIGINT | N/A | N/A |
| BINARY | N/A | N/A |
| BIT | N/A | N/A |
| LONGVARBINARY | N/A | N/A |
| TINYINT | N/A | N/A |
| VARBINARY | N/A | N/A |
Related reference