Home | Previous Page | Next Page   Database Access >

Executing SQL Statements

In This Chapter
Executing SQL Statements
Choosing a DataBlade API Function
Type of Statement
Prepared Statements and Input Parameters
Queries and Implicit Cursors
Executing Basic SQL Statements
Assembling a Statement String
Sending an SQL Statement
Executing Prepared SQL Statements
Preparing an 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
Handling Unsuccessful Statements
Handling a DDL Statement
Handling a DML Statement
Handling Query Rows
Handling "No More Data"
Example: The 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: The 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
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]