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.
The collection-derived table clause on row typesThe collection-derived table clause allows you to create a collection-derived table from a row-type column.

The collection-derived table clause on row types

The collection-derived table clause allows you to create a collection-derived table from a row-type column.

This clause has the following syntax:

TABLE(:row_var)

The variable row_var is a row host variable. It can be either a typed or untyped row host variable but you must declare it beforehand.

For more information about the syntax of the collection-derived table clause, see the description of the collection-derived table segment in the HCL OneDB™ Guide to SQL: Syntax.