DB2 Type Mappings
DB2 10.1 Types to DataFlex Mappings
The following tables show how the DB2 native types map to DataFlex types. All types shown are supported by the DataFlex DB2 Driver. The driver is able to store and retrieve from/to all the mentioned data types.
| DB2 Type | DataFlex Type |
|---|---|
| NUMERIC | Num 0.1 – Num 14.8 |
| DECIMAL | Num 0.1 – Num 14.8 |
| INTEGER | Num 9.0 |
| SMALLINT | Num 5.0 |
| BIGINT | Num 14.0 |
| FLOAT | Num 14.8 |
| REAL | Num 14.8 |
| DOUBLE | Num 14.8 |
| DATE | Date(10.0) |
| TIME | Asc(11) |
| TIMESTAMP | Datetime(23.0) – Datetime(23.6) |
| CHAR(1-255) | Asc(1 – 255) |
| VARCHAR(1-255) | Asc(1 – 255) |
| VARCHAR(256-32672) | Text(256-32672) |
| LONG VARCHAR(1-255) | Asc(1 – 255) |
| LONG VARCHAR(256-32000) | Text(256-32000) |
| CLOB | Text(16383) |
| XML | Text(16383) |
| CHAR FOR BIT DATA(1-254) | Binary(1-254) |
| VARCHAR FOR BIT DATA(1-32672) | Binary(1-32672) |
| LONG VARCHAR FOR BIT DATA | Binary(1-32000) |
| BLOB | Binary(16383) |
| GRAPHIC(1-255) | Asc(1-255) |
| VARGRAPHIC(1-255) | Asc(1-255) |
| VARGRAPHIC(255-32672) | Text(256-32672) |
| LONG VARGRAPHIC(256-32000) | Text(256-32000) |
| DBCLOB | Text(16383) |
DB2 DataFlex to SQL Mappings
The following table shows the DataFlex to SQL type mappings for the DB2 driver.
| DataFlex Type | SQL Type (DB2) | ODBC Type |
|---|---|---|
| DF_ASCII | Char | Varchar |
| Graphic | Vargraphic | SQL_CHAR (1) |
| SQL_VARCHAR (12) | ||
| SQL_GRAPHIC (-95) | ||
| SQL_VARGRAPHIC (-96) | ||
| DF_BCD | SmallInt/Int/Numeric | |
| DF_DATE | Date | SQL_TYPE_DATE (91) |
| DF_DATETIME | Timestamp | SQL_TYPE_TIMESTAMP (93) |
| DF_TEXT | Longvarchar | varchar |
| clob | ||
| vargraphic | ||
| longvargraphic | ||
| dbclob | ||
| DF_BINARY | Long varchar for bit data | Varchar for bit data |
| Char for bit data | Blob | |
| SQL_LONGVARBINARY (-4) | ||
| SQL_VARBINARY (-3) | ||
| SQL_BINARY (-2) | ||
| SQL_BLOB (-98) |
Note: The "Graphic" types are the DB2 Unicode types.