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
Declaring collection variables

Declaring collection variables

About this task

To access the elements of a column that has a collection type (LIST, MULTISET, or SET) as its data type, perform the following steps:

Declare a collection host variable, either typed or untyped.
Allocate memory for the collection host variable.
Perform any select, insert, update, or delete operations on the collection host variable.
Save the contents of the collection host variable into the collection column.