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

Handling a parameterized UPDATE or DELETE statement

How you determine the input parameters in the WHERE clause of a DELETE or UPDATE statement is similar to how you determine them in the WHERE clause of a SELECT statement. For more information, see Handling a parameterized 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. Therefore, you provide the parameter values from a system-descriptor area with the USING SQL DESCRIPTOR clause of the EXECUTE statement instead of the OPEN statement.
You can use the DESCRIBE...USING SQL DESCRIPTOR statement to determine if the DELETE or UPDATE statement has a WHERE clause. For more information, see Check for a WHERE clause.