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
Inserting more than one elementAn insert cursor that includes an INSERT statement with the collection-derived table clause allows you to insert many elements into a collection variable.
Free cursor resources

Free cursor resources

The CLOSE statement explicitly frees resources assigned to the insert cursor. However, the cursor ID still exists, so you can reopen the cursor with the OPEN statement. The FREE statement explicitly frees the cursor ID. To reuse the cursor, you must declare the cursor again with the DECLARE statement.

The FLUSH statement does not effect an insert cursor that is associated with a collection variable. For the syntax of the CLOSE statement, see the Informix® Guide to SQL: Syntax.

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.