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 column list
Execute a simple insert

Execute a simple insert

The following steps outline how to execute a simple INSERT statement with a system-descriptor area:

Prepare the INSERT statement (with the PREPARE statement) and give it a statement identifier.
Set the columns to their values with the SET DESCRIPTOR statement.
Execute the INSERT statement with the EXECUTE...USING SQL DESCRIPTOR statement.