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 elements into a collection variable

To insert one or more elements into a collection variable, use the INSERT statement with the collection-derived table clause after the INTO keyword. The collection- derived table clause identifies the collection variable in which to insert the elements. Associate the INSERT statement and the collection-derived table clause with a cursor to insert more than one element into a collection variable.

Restriction: You cannot use expressions in the VALUES clause and you cannot use a WHERE clause.

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.