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
Specify element values

Specify element values

You can specify any of the following values as elements in a collection variable:

A literal value
You can also specify literal values directly for a collection column without first using a collection variable. For more information, see Insert into and update a collection column.
The host variable
The host variable must contain a value whose data type is compatible with the element type of the collection.

You cannot include complex expressions directly to specify values.

For information about how to insert elements into a collection variable, see Insert elements into a collection variable. For information about how to update elements in a collection variable, see Update a collection variable. The following sections describe the values you can assign to an element in a collection variable.