Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ ODBC Driver GuideThe HCL OneDB™ ODBC Driver Programmer's Manual serves as a user guide and reference for HCL OneDB™ ODBC Driver, which is the HCL OneDB™ implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Data typesThese topics contain information about the data types that are supported by HCL OneDB™ ODBC Driver.
Convert dataThe word convert is used in this section in a broad sense; it includes the transfer of data from one storage location to another without a conversion in data type.
Additional conversions for HCL OneDB™There are supported conversions between the additional HCL OneDB™ SQL data types for HCL OneDB™ and the HCL OneDB™ ODBC Driver C data types.

Additional conversions for HCL OneDB

There are supported conversions between the additional HCL OneDB™ SQL data types for HCL OneDB and the HCL OneDB ODBC Driver C data types.

The HCL OneDB SQL data types, Collection, DISTINCT, Row, and Smart large object, support conversions between the following HCL OneDB ODBC driver C data types (fCType):

SQL_C_BINARY
SQL_C_BIT
SQL_C_CHAR
SQL_C_DATE
SQL_C_DOUBLE
SQL_C_FLOAT
SQL_C_LONG
SQL_C_SHORT
SQL_C_SLONG
SQL_C_SSHORT
SQL_C_STINYINT
SQL_C_TIMESTAMP
SQL_C_TINYINT
SQL_C_ULONG
SQL_C_USHORT
SQL_C_UTINYINT

The HCL OneDB SQL data type OPAQUE supports conversion between the SQL_C_BINARY and SQL_C_CHAR ODBC driver C data types (fCType). Use SQL_C_CHAR to access an OPAQUE value in the external format as a string. Use SQL_C_BINARY to access an OPAQUE value in the internal binary format.