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
Delete elements from a collection variableAfter you have initialized a collection host variable with a collection column, you can use the DELETE statement and the collection-derived table clause to delete an element of a collection variable. The collection-derived table clause identifies the collection variable in which to delete the elements.

Delete elements from a collection variable

After you have initialized a collection host variable with a collection column, you can use the DELETE statement and the collection-derived table clause to delete an element of a collection variable. The collection-derived table clause identifies the collection variable in which to delete the elements.

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

Delete all elements in the collection.
Use the DELETE statement (without the WHERE CURRENT OF clause).
Delete a particular element in the collection.
You must declare an update cursor for the collection variable and use DELETE with the WHERE CURRENT OF clause.

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