ASA Programming Guide
Embedded SQL Programming
Fetching data in embedded SQL is done using the SELECT statement. There are two cases:
The SELECT statement returns at most one row Use an INTO clause to assign the returned values directly to host variables.
For information, see SELECT statements that return at most one row.
The SELECT statement may return multiple rows Use cursors to manage the rows of the result set.
For more information, see Using cursors in embedded SQL.
LONG VARCHAR and LONG BINARY data types are handled differently to other data types. For more information, see Retrieving LONG data.
SELECT statements that return at most one row
Using cursors in embedded SQL
Fetching more than one row at a time