Progress
Embedded SQL-92
Guide and Reference
FETCH Rows Using a Cursor
The FETCH statement advances the cursor to the next row in the active set and retrieves the values from that row. When the FETCH statement is executed for the first time, the cursor is positioned on the first row, and all the column values of the first row are retrieved. Subsequent calls to FETCH retrieve rows one by one from the active set. When all the rows in the active set are retrieved, SQL_NOT_FOUND is set in the SQLCA to indicate that all rows have been retrieved.
EXAMPLEThe following example shows how to use the FETCH statement:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |