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