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 C to SQLWhen you call SQLExecute or SQLExecDirect, HCL OneDB™ ODBC Driver retrieves the data for parameters that are bound with SQLBindParameter from storage locations in the application.
C to SQL: BitThe bit HCL OneDB™ ODBC Driver C data type is SQL_C_BIT.

C to SQL: Bit

The bit HCL OneDB™ ODBC Driver C data type is SQL_C_BIT.

The following table shows the HCL OneDB ODBC Driver SQL data types to which bit C data can be converted.


fSqlType	Test	SQLSTATE
SQL_BIGINT SQL_DECIMAL SQL_DOUBLE SQL_INTEGER SQL_REAL SQL_SMALLINT	None	N/A
SQL_BIT	None	N/A
SQL_CHAR SQL_LONGVARCHAR SQL_VARCHAR	None	N/A

HCL OneDB ODBC Driver ignores the value that the pcbValue argument of SQLBindParameter points to and the value of the cbValue argument of SQLPutData when it converts data from the Boolean C data type. HCL OneDB ODBC Driver uses the size of rgbValue for the size of the Boolean C data type.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.