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
A system-descriptor areaA 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.
Handling an unknown select list
Execute a SELECT that returns multiple rows

Execute a SELECT that returns multiple rows

The demo4.ec sample program shows how to execute a dynamic SELECT statement with the following conditions:

The SELECT returns more than one row.
The SELECT must be associated with a cursor, executed with the OPEN statement, and have its return values retrieved with the FETCH...USING SQL DESCRIPTOR statement.
The SELECT has either no input parameters or no WHERE clause.
The OPEN statement does not need to include the USING clause.
The SELECT has unknown columns in its select list.
The FETCH statement includes the USING SQL DESCRIPTOR clause to store the return values in an sqlda structure.