Tutorial Chapter 4: Query by Example

Parent topic: Tutorial Chapter 4: Query by Example

Retrieving data from the Database

When an SQL SELECT statement in your application will retrieve more than one row, a cursor must be used to pass the selected data to the program one row at a time.

Using SQL Cursors
An SQL cursor is an object that handles the set of rows produced by a SELECT statement.
The SQLCA.SQLCODE
The SQLCA name stands for "SQL Communication Area". The SQLCA variable is a predefined record containing information on the execution of an SQL statement.

Parent topic: Tutorial Chapter 4: Query by Example