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.
Dynamic SQL
Using dynamic SQL
A database cursorA database cursor is an identifier associated with a group of rows. It is, in a sense, a pointer to the current row in a buffer.
Optimize cursor execution

Optimize cursor execution

Informix® ESQL/C supports the following features that allow you to minimize network traffic when the Informix ESQL/C application fetches rows from a database server:

Change the size of the fetch and insert buffers
Automatically free the cursor
Defer the PREPARE statement until the OPEN statement

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.