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 all elements

Delete all elements

You cannot include a WHERE clause on a DELETE statement with a collection-derived table clause. Therefore, a DELETE statement on a collection variable deletes all elements from the collection. No update cursor is required to delete all elements of a collection.

For example, the following DELETE removes all elements in the a_list collection variable:

EXEC SQL BEGIN DECLARE SECTION;
   client collection list(smallint not null) a_list;
EXEC SQL END DECLARE SECTION;
;

EXEC SQL delete from table(:a_list);