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 column listYou can use an sqlda structure to handle the INSERT...VALUES statement
Execute a simple insert

Execute a simple insert

The following steps outline how to execute a simple INSERT statement with an sqlda structure:

Prepare the INSERT statement (with the PREPARE statement) and give it a statement identifier.
Set the columns to their values with C-language statements that set the appropriate sqldata fields in the sqlvar_struct structures of sqlda.
Execute the INSERT statement with the EXECUTE...USING DESCRIPTOR statement.

These steps are basically the same as those that handle an unknown select list of a SELECT statement. The major difference is that because the statement is a not a SELECT statement, the INSERT does not require a cursor.