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.
Rows and collectionsRows and collections are composite values that consist of one or more elements.
Allocating and binding a row or collection bufferWhen you retrieve a row or collection, the database server puts the row or collection into a buffer that is local to your HCL OneDB™ ODBC Driver application.
SQL dataThe database server calls cast functions to convert the data from the source HCL OneDB™ SQL data types to the target HCL OneDB™ SQL data types.

SQL data

The database server calls cast functions to convert the data from the source HCL OneDB™ SQL data types to the target HCL OneDB SQL data types.

If the data types for a row or collection that are on a database server differ from the data types for a row or collection buffer into which the data is retrieved, the database server calls cast functions to convert the data from the source HCL OneDB SQL data types to the target HCL OneDB SQL data types. The following table lists the provider of the cast functions for each combination of source data type and target data type. Cast functions that a data type provides are located on the database server.


Source data type	Target data type	Provider of cast functions
Built-in	Built-in	Database server
Built-in	Extended	Data type
Extended	Built-in	Data type
Extended	Extended	Data type