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.
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.
Dynamic SQL
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.
What is
HCL OneDB™
ESQL/C?
Database server communication
Dynamic SQL
Using dynamic SQL
Determine SQL statements
If you do not know until run time what SQL statement to execute, you can dynamically determine that statement with the DESCRIBE statement and use a dynamic-management structure to hold any values that the statement sends to or receives from the database server.
A system-descriptor area
A system-descriptor area is a dynamic-management structure that can hold data that a prepared statement either returns from or sends to the database server. A system-descriptor area conforms to X/Open standards.
An sqlda structure
An
sqlda
structure is a dynamic-management structure that can hold data that is either returned from or sent to the database server by a prepared statement. It is a C structure defined in the
sqlda.h
header file.
Appendixes
This section contains additional reference information.
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
.
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.
Dynamic SQL
Using dynamic SQL
Determine SQL statements
If you do not know until run time what SQL statement to execute, you can dynamically determine that statement with the DESCRIBE statement and use a dynamic-management structure to hold any values that the statement sends to or receives from the database server.
A system-descriptor area
A system-descriptor area is a dynamic-management structure that can hold data that a prepared statement either returns from or sends to the database server. A system-descriptor area conforms to X/Open standards.
An sqlda structure
An
sqlda
structure is a dynamic-management structure that can hold data that is either returned from or sent to the database server by a prepared statement. It is a C structure defined in the
sqlda.h
header file.