Jump to main content
Product Documentation
Customer Support
HCL OneDB 2.0.1
What's new in
HCL OneDB™
2.0.1
Getting Started
Installing
Administering
Migrating and upgrading
Data warehousing
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
Troubleshooting
HCL OneDB™
OneDB PDF guides
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.
What is
HCL OneDB™
ODBC Driver?
Open Database Connectivity (ODBC) is a specification for a database application programming interface (API).
HCL OneDB™
ODBC Driver features
HCL OneDB™ ODBC Driver
implements the Microsoft™ Open Database Connectivity (ODBC), Version
3.0
standard.
Extended error detection
HCL OneDB™ ODBC Driver
detects the
ISM and
XA types of errors.
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).
HCL OneDB™
ODBC Driver features
HCL OneDB™ ODBC Driver
implements the Microsoft™ Open Database Connectivity (ODBC), Version
3.0
standard.
Support for extended data types
HCL OneDB™ ODBC Driver
supports the extended data types.
Support for GLS data types
HCL OneDB™ ODBC Driver
supports the GLS data types.
Extended error detection
HCL OneDB™ ODBC Driver
detects the
ISM and
XA types of errors.
Additional values for some ODBC function arguments
HCL OneDB™ ODBC Driver
supports additional values for some ODBC function arguments.
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.
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.
OneDB .NET EF(Entity Framework) Core Provider
The
.NET EF Core Provider
for OneDB® is used for developing .NET EF Core 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.
Extended error detection
HCL OneDB™ ODBC Driver
detects the
ISM and
XA types of errors.
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.