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.
Convert data from SQL to CWhen you call SQLExtendedFetch, SQLFetch, or SQLGetData, HCL OneDB™ ODBC Driver retrieves data from a data source.
Default C data typesYou can specify the SQL_C_DEFAULT for different functions so that HCL OneDB™ ODBC Driver uses the C data type.
Standard default C data typesThere is default C data type for each HCL OneDB™ ODBC Driver SQL data type.

Standard default C data types

There is default C data type for each HCL OneDB™ ODBC Driver SQL data type.

For each HCL OneDB ODBC Driver SQL data type, the following table shows the default C data type.


HCL OneDB ODBC driver SQL data type (fSqlType)	Default HCL OneDB ODBC driver C data type (fCType)
SQL_BIGINT	SQL_C_CHAR
SQL_BIT	SQL_C_BITS
SQL_CHAR	SQL_C_CHAR
SQL_DATE	SQL_C_DATE
SQL_DECIMAL	SQL_C_CHAR
SQL_DOUBLE	SQL_C_DOUBLE
SQL_INTEGER	SQL_C_SLONG
SQL_LONGVARBINARY	SQL_C_BINARY
SQL_LONGVARCHAR	SQL_C_CHAR
SQL_NUMERIC	SQL_C_NUMERIC
SQL_REAL	SQL_C_FLOAT
SQL_SMALLINT	SQL_C_SSHORT
SQL_TIMESTAMP	SQL_C_TIMESTAMP
SQL_VARCHAR	SQL_C_CHARS