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.
Receive more than one row
A select cursorA select cursor enables you to scan multiple rows of data that a SELECT statement returns. The DECLARE statement associates the SELECT statement with the select cursor.

A select cursor

A select cursor enables you to scan multiple rows of data that a SELECT statement returns. The DECLARE statement associates the SELECT statement with the select cursor.

In the DECLARE statement, the SELECT statement can be in either of the following formats:

A literal SELECT statement in the DECLARE statement
The following DECLARE statement associates a literal SELECT statement with the slct1_curs cursor:
```
EXEC SQL declare slct1_curs cursor for select * from customer;
```
A prepared SELECT statement in the DECLARE statement
The following DECLARE statement associates a prepared SELECT statement with the slct2_curs cursor:
```
EXEC SQL prepare slct_stmt cursor from
      'select * from customer';
EXEC SQL declare slct2_curs for slct_stmt;
```

If the SELECT returns only one row, it is called a singleton SELECT and it does not require a select cursor to execute.