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 row types
Declare row variables
Client-side rows

Client-side rows

A row variable is sometimes called a client-side row. When you declare a row variable, you must declare the row variable name, allocate memory, and perform operations on the row.

To access the elements of a row variable, you specify the variable in the collection-derived table clause of a SELECT or UPDATE statement. When either of these statements contains a collection-derived table clause, performs the select or update operation on the row variable; it does not send these statements to the database server for execution. For example, executes the update operation on the row variable, a_row, that the following UPDATE statement specifies:

EXEC SQL update table(:a_row) set fld1 = 6;

To access fields of a row type, you must use the SELECT or UPDATE statements with the collection-derived table clause.

For more information about the collection-derived table clause, see Access a collection.