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.

A system-descriptor area

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

These topics contain the following information about how to use a system-descriptor area:

Managing a system-descriptor area for dynamic SQL
Using a system-descriptor area to handle unknown values in dynamic SQL statements

The end of this section presents an annotated example program called dyn_sql that uses a system-descriptor area to process a SELECT statement entered at run time.