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
Select from a collection variableThe SELECT statement with the collection-derived table clause allows you to select elements from a collection variable.
Select one row elementYou can select an entire row element from a collection into a row type host variable.

Select one row element

You can select an entire row element from a collection into a row type host variable.

The INTO clause identifies a row variable in which to store the row element that is selected from the collection variable.

The following code fragment selects one row from the set_col column into the row type host variable a_row:

EXEC SQL BEGIN DECLARE SECTION;
   client collection set(row(a integer) not null) a_set;
   row (a integer) a_row;
EXEC SQL END DECLARE SECTION;

EXEC SQL select set_col into :a_set from tab1
   where id_col = 17;
EXEC SQL select * into :a_row from table(:a_set);