Informix Guide to SQL: Tutorial
Chapter 5: Programming with SQL
Home
Contents
Index
Master Index
New Book
Programming with SQL
SQL in Programs
SQL in SQL APIs
Static Embedding
Dynamic Statements
Program Variables and Host Variables
Calling the Database Server
The SQL Communications Area
The SQLCODE Field
End of Data
Negative Codes
The SQLERRD Array
The SQLWARN Array
The SQLERRM Character Array
The SQLSTATE Value
Retrieving Single Rows
Data Type Conversion
Working with Null Data
Dealing with Errors
End of Data
End of Data with Databases That Are Not ANSI Compliant
Serious Errors
Interpreting End of Data with Aggregate Functions
Using Default Values
Retrieving Multiple Rows
Declaring a Cursor
Opening a Cursor
Fetching Rows
Detecting End of Data
Locating the INTO Clause
Cursor Input Modes
The Active Set of a Cursor
Creating the Active Set
The Active Set for a Sequential Cursor
The Active Set for a Scroll Cursor
The Active Set and Concurrency
Using a Cursor: A Parts Explosion
Dynamic SQL
Preparing a Statement
Executing Prepared SQL
Dynamic Host Variables
Freeing Prepared Statements
Quick Execution
Embedding Data Definition Statements
Embedding Grant and Revoke Privileges
Summary
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
