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 a parameterized SELECT statement
Execute a parameterized SELECT that returns multiple rows

Execute a parameterized SELECT that returns multiple rows

The following sample program shows how to use a dynamic SELECT statement with the following conditions:

The SELECT returns more than 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 input parameters in its WHERE clause.
The OPEN statement includes the USING SQL DESCRIPTOR clause to provide the parameter values in a system-descriptor area.
The SELECT has unknown columns in the select list.
The FETCH statement includes the USING SQL DESCRIPTOR clause to store the return values in a system-descriptor area.