Progress
DataServer
for ORACLE Guide
Cursors
Progress uses cursors to keep track of where it is in a file. A cursor is like a pointer that points to consecutive records in a file. For example, Progress uses cursors when it processes FOR EACH types of statements. Progress maintains cursor positioning across queries.
The DataServer supports this behavior for ORACLE tables that have a mandatory unique index on an integer column or that contain the PROGRESS_RECID column. (The Progress-to-ORACLE migration utility creates an indexed NUMBER column named PROGRESS_RECID with unique values for the rows in each ORACLE table.)
Suppose that you are reading records from the customer file using the CUST-NUM index, and your “current” record is customer number 50. This means that Progress has a cursor positioned at cust-num 50.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |