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
Insert elements into a collection variable
Insert one elementThe INSERT statement and the collection-derived table clause allow you to insert one element into a collection.

Insert one element

The INSERT statement and the collection-derived table clause allow you to insert one element into a collection.

inserts the values that the VALUES clause specifies into the collection variable that the collection-derived table clause specifies.

Tip: When you insert elements into a client-side collection variable, you cannot specify a SELECT, an EXECUTE FUNCTION, or an EXECUTE PROCEDURE statement in the VALUES clause of the INSERT.