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 column
Select from a collection column

Select from a collection column

To select all elements in a collection column, specify the collection column in the select list of the SELECT statement. If you put a collection host variable in the INTO clause of the SELECT statement, you can access these elements from the application. For more information, see Initialize a collection variable. For an example that uses a collection variable to select and display the elements of a collection, see The collect.ec program.