Jump to main content
Product Documentation
Customer Support
HCL OneDB V 1.0.1.0
What's new in
HCL OneDB™
1.0.1.0
Getting Started
Installing
Administering
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
Search
Home
Client APIs and tools
You can use the
HCL OneDB™
implementation of client APIs to develop applications for
HCL OneDB™
database servers.
HCL OneDB™
ODBC Driver Guide
The
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
.
Overview of
HCL OneDB™
ODBC Driver
These topics introduce the
HCL OneDB™ ODBC Driver
and describe its advantages and architecture. The topics also describe conformance, isolation and lock levels, libraries, and environment variables.
Partially supported and unsupported ODBC features
HCL OneDB™ ODBC Driver
supports partial implementation of several ODBC features.
SQLBulkOperations
HCL OneDB™ ODBC Driver
supports only the SQL_ADD argument of
SQLBulkOperations
.
Client APIs and tools
You can use the
HCL OneDB™
implementation of client APIs to develop applications for
HCL OneDB™
database servers.
Change Data Capture API Programmer's Guide
These topics describe how to program applications to process changed data from
HCL OneDB™
databases using the
HCL® OneDB® Change Data Capture API
.
The
HCL OneDB™
Change Data Capture API Programmer's Guide
describes how to program applications to process changed data from
HCL OneDB™
databases using the
HCL® OneDB® Change Data Capture API
.
ESQL/C Guide
The
HCL OneDB™
ESQL/C Programmer's Manual
explains how to use , the
HCL OneDB™
implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
GLS User's Guide
These topics describe the Global Language Support (GLS) feature available in
HCL® OneDB®
products.
The
HCL OneDB™
GLS User's Guide
describes the Global Language Support (GLS) feature available in
HCL® OneDB®
products.
HCL OneDB™
ODBC Driver Guide
The
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
.
Overview of
HCL OneDB™
ODBC Driver
These topics introduce the
HCL OneDB™ ODBC Driver
and describe its advantages and architecture. The topics also describe conformance, isolation and lock levels, libraries, and environment variables.
What is
HCL OneDB™
ODBC Driver?
Open Database Connectivity (ODBC) is a specification for a database application programming interface (API).
ODBC component overview
ODBC with the
HCL OneDB™ ODBC Driver
includes several components.
HCL OneDB™
ODBC Driver with the DMR
HCL OneDB™ ODBC Driver
includes a Driver Manager Replacement (DMR) library. The DMR replaces the driver manager on platforms where no driver manager is available.
HCL OneDB™
ODBC Driver components
HCL OneDB™ ODBC Driver
includes the four components.
The
HCL OneDB™
ODBC Driver API
An application uses the
HCL OneDB™ ODBC Driver
API to make a connection to a data source, send SQL statements to a data source, process result data dynamically, and terminate a connection.
Connection pooling
OneDB ODBC driver also supports Connection Pooling capabilities. One may decide to use either Connection Pooling capabilities provided by ODBC Driver Manager or newly added capabilities in OneDB ODBC Driver
Global Language Support
HCL OneDB™
products can support many languages, cultures, and code sets. Global Language Support (GLS) provides support for all language- and culture-specific information.
X/Open standard interface
In addition to the standard ODBC functions, the
HCL OneDB™ ODBC Driver
also supports the additional functions.
External authentication
For
HCL OneDB™
Version 10.0 and later, you can implement external authentication through the
HCL OneDB™ ODBC Driver
.
Bypass ODBC parsing
You can bypass ODBC parsing by using several options.
BufferLength in character for SQLGetDiagRecW
The
SQLGetDiagRecW
API returns diagnostic information in the output buffer, where the BufferLength parameter is the length of buffer allocated.
HCL OneDB™
and ISAM error descriptions in SQLGetDiagRec
The
SQLGetDiagRec
API returns diagnostic information in the output buffer, where the error description is for the
HCL OneDB™
error message.
Improved performance for single-threaded applications
You are likely to improve the performance of single-threaded applications by using the SINGLETHREADED connection parameter. The value is off by default.
Partially supported and unsupported ODBC features
HCL OneDB™ ODBC Driver
supports partial implementation of several ODBC features.
Transaction processing
HCL OneDB™ ODBC Driver
implementation of transaction isolation levels and transaction modes is slightly different from the Microsoft™ ODBC implementation of these features.
ODBC cursors
HCL OneDB™ ODBC Driver
supports static and forward cursors but not dynamic and keyset-driven cursors.
ODBC bookmarks
A
bookmark
is a value that identifies a row of data.
SQLBulkOperations
HCL OneDB™ ODBC Driver
supports only the SQL_ADD argument of
SQLBulkOperations
.
SQLDescribeParam
SQLDescribeParam
is an ODBC API which returns metadata for the parameters of a query.
Unsupported Microsoft™ ODBC driver features
HCL OneDB™ ODBC Driver
does not support implementation of the certain Microsoft™ ODBC driver features.
Configure data sources
These topics explain how to configure a data source (DSN) on UNIX™ and Windows™ for
HCL OneDB™ ODBC Driver
.
Data types
These topics contain information about the data types that are supported by
HCL OneDB™ ODBC Driver
.
Smart large objects
These topics describe how to store, create, and access a smart large object; how to transfer smart-large-object data; how to retrieve the status of a smart large object; and how to read or write a smart large object to or from a file.
Rows and collections
Rows and collections are composite values that consist of one or more elements.
Client functions
These topics describe the
HCL OneDB™ ODBC Driver
client functions. Use these functions to access and manipulate smart large objects and rows and collections.
Improve application performance
These topics suggest ways to improve performance of
HCL OneDB™ ODBC Driver
applications.
Error messages
These topics describe the
HCL OneDB™ ODBC Driver
error messages.
Unicode
These topics provide a brief overview of the Unicode standard and shows how it is used within ODBC applications.
ODBC Smart trigger
OneDB .NET Core Provider
The
.NET Core Provider
for OneDB® is used for developing .NET applications.
HCL OneDB™
JDBC Driver Guide
The
HCL OneDB™ JDBC Driver Programmer's Guide
describes how to install, load, and use
HCL OneDB™ JDBC Driver
to connect to the
HCL OneDB™
database from within a Java™ application.
HCL OneDB™
REST API Guide
The
HCL OneDB™
REST API allows application developers to access data in their
HCL OneDB™
database server through simple HTTP requests. Applications can query, insert, load, update, and delete data in relational tables, in JSON collections, or in TimeSeries tables all through simple, JSON-based REST requests.
SQLBulkOperations
HCL OneDB™ ODBC Driver
supports only the SQL_ADD argument of
SQLBulkOperations
.