DB2 Type Changes
DB2 10.1 Types to DataFlex Mappings
The following tables show how the DB2 10.1 native types map to a DataFlex type. All types shown are supported by CK6. The CK 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) |
DataFlex to SQL Mappings
The following table shows the DataFlex to SQL mappings in CK5 and the allowed new mappings in CK6 for DB2 10.1.
| Current DF – SQL Mapping (CK5) | DB2 Type | New DF – SQL Mapping (CK6) | DB2 Type |
|---|---|---|---|
| DataFlex Type | SQL Type | DataFlex Type | SQL Type |
| DF_ASCII | Char | DF_ASCII | Char |
| Varchar | |||
| Graphic | Vargraphic | ||
| SQL_CHAR (1) | |||
| SQL_VARCHAR (12) | |||
| SQL_GRAPHIC (-95) | |||
| SQL_VARGRAPHIC (-96) | |||
| DF_BCD | SmallInt/Int/Numeric | DF_BCD | SmallInt/Int/Numeric |
| DF_DATE | Date | DF_DATE | Date |
| SQL_TYPE_DATE (91) | |||
| DF_DATETIME | Timestamp | DF_DATETIME | Timestamp |
| SQL_TYPE_TIMESTAMP (93) | |||
| DF_TEXT | Varchar | DF_TEXT | Longvarchar |
| varchar | |||
| clob | |||
| longvargraphic | |||
| vargraphic | |||
| dbclob | |||
| SQL_LONGVARCHAR (-1) | |||
| SQL_VARCHAR (12) | |||
| SQL_CLOB (-99) | |||
| SQL_VARGRAPHIC (-96) | |||
| SQL_LONGVARGRAPHIC (-97) | |||
| SQL_DBCLOB (-350) | |||
| DF_BINARY | Varchar for bit data | 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.
See Also
- Connectivity Kits Version 6