Informix DataBlade API Programmer's Manual Executing SQL Statements

In This Chapter

Executing SQL Statements

Choosing the DataBlade API Function

Statement Type

Prepared Statements and Input Parameters

Queries and Implicit Cursors

Executing Basic SQL Statements

Assembling the Statement String

Sending the SQL Statement

Executing Prepared SQL Statements

Preparing the SQL Statement

Obtaining Input-Parameter Information

Sending the Prepared Statement

Releasing Prepared-Statement Resources

Executing Multiple SQL Statements

Processing Statement Results

Executing the mi_get_result() Loop

Interpreting Statement Status

Handling Unsuccessful Statements

Handling a DDL Statement

Handling a DML Statement

Handling Query Rows

Handling "No More Data"

Example: get_results() Function

Retrieving Query Data

Obtaining Row Information

Obtaining Column Information

Retrieving Rows

Accessing the Current Row

Executing the mi_next_row() Loop

Obtaining Column Values

Executing the Column-Value Loop

Accessing the Columns

Obtaining Normal Values

Obtaining NULL Values

Obtaining Row Values

Obtaining Collection Values

Example: get_data() Function

Completing Execution

Finishing Execution

Processing Remaining Rows

Releasing Statement Resources

Interrupting Execution

Inserting Data Into the Database

Assembling an Insert String

Sending the Insert Statement

Processing Insert Results

Using Save Sets

Creating a Save Set

Inserting Rows into a Save Set

Building a Save Set

Freeing a Save Set