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
Operate on a row variableThe SELECT, and UPDATE statements allow you to access a row-type column as a whole.
Specify field values
Constructed rowsYou can use a constructed row to specify an expression as a field value for a row variable. The constructed expression must use a row constructor and evaluate to a data type that is compatible with the field type of the field.

Constructed rows

You can use a constructed row to specify an expression as a field value for a row variable. The constructed expression must use a row constructor and evaluate to a data type that is compatible with the field type of the field.

Suppose you have a nested-row variable that is declared as follows:

EXEC SQL BEGIN DECLARE SECTION;
   row (fld1 integer, fld2 row(x smallint, y char(5))) a_nested_row;
EXEC SQL END DECLARE SECTION;

The following UPDATE statement uses the ROW constructor to specify expressions in the value for the fld2 field of the a_nested_row variable:

EXEC SQL update table(:a_nested_row) 
   set fld2 = row(:an_int, a_func(:a_strng));

For more information about the syntax of a row constructor, see the Expression segment in the HCL OneDB™ Guide to SQL: Syntax.