Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
ESQL/C GuideThe topics explain how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. The HCL® OneDB® ESQL/C Programmer's Manual explains how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
Dynamic SQL
Using dynamic SQL
A database cursorA database cursor is an identifier associated with a group of rows. It is, in a sense, a pointer to the current row in a buffer.
Optimize cursor execution

Optimize cursor execution

HCL OneDB™ ESQL/C supports the following features that allow you to minimize network traffic when the HCL OneDB ESQL/C application fetches rows from a database server:

Change the size of the fetch and insert buffers
Automatically free the cursor
Defer the PREPARE statement until the OPEN statement