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
An sqlda structureAn 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.
Handling an unknown select list
Execute a SELECT that returns multiple rows

Execute a SELECT that returns multiple rows

The demo3.ec sample program executes 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 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 DESCRIPTOR clause to store the return values in an sqlda structure.