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?
Compile programs
The esql command
Options that affect preprocessing
Cursor names and statement IDsBy default, Informix® ESQL/C defines cursor names and statement IDs as global entities. If you use the -local option, static cursor names and static statement IDs that you declare in a file are local to that file.

Cursor names and statement IDs

By default, Informix® ESQL/C defines cursor names and statement IDs as global entities. If you use the -local option, static cursor names and static statement IDs that you declare in a file are local to that file.

To create the local name, Informix ESQL/C adds a unique tag (two to nine characters long) to the cursor names and statement IDs in the Informix ESQL/C program. If the combined length of the cursor name (or statement ID) and the unique tag exceeds 128 characters, you receive a warning message.

The -local option is provided primarily for compatibility with applications that were created in previous versions of Informix ESQL/C. Do not use this option when you compile new applications. Do not mix files compiled with and without the -local flag. If you mix them, you might receive unpredictable results.

If you use the -local option, you must recompile the source files every time you rename them.

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.