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.
What is HCL OneDB™ ESQL/C?
Complex data typesThese topics explain how to use collection and row data types in the program.
Access a collection
Operate on a collection variable
Update a collection variableAfter you have initialized a collection host variable with a collection column, you can use the UPDATE statement with the collection-derived table clause to update the elements in the collection. The collection-derived table clause identifies the collection variable whose elements are to be updated.

Update a collection variable

After you have initialized a collection host variable with a collection column, you can use the UPDATE statement with the collection-derived table clause to update the elements in the collection. The collection-derived table clause identifies the collection variable whose elements are to be updated.

The UPDATE statement and the collection-derived table clause allow you to perform the following operations on a collection variable:

Update all elements in the collection to the same value.
Use the UPDATE statement (without the WHERE CURRENT OF clause) and specify a derived column name in the SET clause.
Update a particular element in the collection.
You must declare an update cursor for the collection variable and use UPDATE with the WHERE CURRENT OF clause.

Neither form of the UPDATE statement can include a WHERE clause.