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.
The dyn_sql program

The dyn_sql program

The dyn_sql.ec program is the demonstration program that uses dynamic SQL. The program prompts the user to enter a SELECT statement for the stores7 demonstration database and then uses a system-descriptor area to execute the SELECT dynamically.

By default, the program opens the stores7 database. If the demonstration database was given a name other than stores7, however, you can specify the database name on the command line. The following command runs the dyn_sql executable on the mystores7 database:

dyn_sql mystores7