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 topics explain how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. The HCL® OneDB® ESQL/C Programmer's Manual explains how to use HCL OneDB™ ESQL/C, 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 HCL OneDB™ ESQL/C 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 HCL OneDB™ ESQL/C application. For more information, see ids_esqlc_0296.html#ids_esqlc_0296. For an example that uses a collection variable to select and display the elements of a collection, see The collect.ec program.