DSN settings for report standard ODBC data types

For UNIX™ and Windows™, you can add the new DSN option NeedODBCTypesOnly.

For UNIX, add a new DSN option NeedODBCTypesOnly under your DSN setting in your odbc.ini file [default is 0]. For example: 
[Informix9]
Driver=/informix/lib/cli/libthcli.so
Description=IBM Informix ODBC Driver
...
NeedODBCTypesOnly=1

For Windows, check this option under the Advanced tab of the ODBC Administration for HCL OneDB™ Driver DSN [default is 0].

The following table shows how the HCL OneDB data types map to the standard ODBC data types.
Table 1. HCL OneDB and ODBC data type mapping
HCL OneDB ODBC
Bigint SQL_BIGINT
Bigserial SQL_BIGINT
Blob SQL_LONGVARBINARY
Boolean SQL_BIT
Clob SQL_LONGVARCHAR
Int8 SQL_BIGINT
Lvarchar SQL_VARCHAR
Serial8 SQL_BIGINT
Multiset SQL_C_CHAR or SQL_C_BINARY
Set SQL_C_CHAR or SQL_C_BINARY
List SQL_C_CHAR or SQL_C_BINARY
Row SQL_C_CHAR or SQL_C_BINARY
Important:
  • For multiset, set, row, and list data types, the data type is mapped to the defaultUDTFetchType attribute set (SQL_C_CHAR or SQL_C_BINARY).
  • To enable SQL_BIGINT to work correctly with SQLBindCol and SQLBindParameter, you must use SQL_C_UBIGINT (which has a supported data range of 8 byte unsigned integer) and not SQL_C_LONG (which has a supported data range of 4 byte integer).