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 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
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.

A database cursor

A 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.

You must use a cursor in the following cases:

Statements that return more than one row of data from the database server:
- A SELECT statement requires a select cursor.
- An EXECUTE FUNCTION statement requires a function cursor.
An INSERT statement that sends more than one row of data to the database server requires an insert cursor.

For more information about how to use cursors, see the HCL OneDB™ Guide to SQL: Tutorial.