Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
ESQL/C GuideThe Informix® ESQL/C Programmer's Manual explains how to use Informix® ESQL/C, the Informix® implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
What is Informix® ESQL/C?
Complex data typesThese topics explain how to use collection and row data types in the Informix® ESQL/C 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.

Informix® ESQL/C 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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.