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
Update a collection variableAfter you have initialized a collection host variable with a collection column, you can use the UPDATE statement with the collection-derived table clause to update the elements in the collection. The collection-derived table clause identifies the collection variable whose elements are to be updated.

Update a collection variable

After you have initialized a collection host variable with a collection column, you can use the UPDATE statement with the collection-derived table clause to update the elements in the collection. The collection-derived table clause identifies the collection variable whose elements are to be updated.

The UPDATE statement and the collection-derived table clause allow you to perform the following operations on a collection variable:

Update all elements in the collection to the same value.
Use the UPDATE statement (without the WHERE CURRENT OF clause) and specify a derived column name in the SET clause.
Update a particular element in the collection.
You must declare an update cursor for the collection variable and use UPDATE with the WHERE CURRENT OF clause.

Neither form of the UPDATE statement can include 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.