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 a parameterized UPDATE or DELETE statement

Handling a parameterized UPDATE or DELETE statement

The way to determine the input parameters in the WHERE clause of a DELETE or UPDATE statement is similar to the way to determine them in the WHERE clause of a SELECT statement. The major differences between these two types of dynamic parameterized statements are as follows:

You do not need to use a cursor to handle a DELETE or UPDATE statement. You provide the parameter values from an sqlda structure with the USING DESCRIPTOR clause of the EXECUTE statement instead of with the OPEN statement.
You can use the DESCRIBE...INTO statement to determine if the DELETE or UPDATE statement has a WHERE clause.