INFORMIX-ESQL/C Programmer's Manual Using Dynamic SQL

Using Dynamic SQL

Assembling and Preparing the SQL Statement

Assembling the Statement

Preparing Statements That Have Collection Variables

Checking the Prepared Statement

Executing the SQL Statement

Freeing Resources

Using a Database Cursor

Receiving More Than One Row

A Select Cursor

A Function Cursor

Sending More Than One Row

Naming the Cursor

Optimizing Cursor Execution

Sizing the Cursor Buffer

Automatically Freeing a Cursor

Deferring Execution of the PREPARE Statement

The collect.ec Program

Optimizing OPEN, FETCH, and CLOSE

Restrictions on OPTOFC

Enabling the OPTOFC Feature

Using OPTOFC and Deferred-PREPARE Together

SQL Statements That Are Known at Compile Time

Executing Non-SELECT Statements

Using PREPARE and EXECUTE

Using EXECUTE IMMEDIATE

Executing SELECT Statements

Using PREPARE and EXECUTE INTO

Using a Select Cursor

The lvarptr.ec Program

Executing User-Defined Routines in Informix
Dynamic Server

A User-Defined Procedure

A User-Defined Function

Executing Statements with Input Parameters

Using an EXECUTE USING Statement

Using an OPEN USING Statement

SQL Statements That Are Not Known at Compile Time