Progress
DataServer
for ORACLE Guide
Index Repositioning
The DataServer supports index repositioning, which allows you to scroll through a query result set. You must define the query as SCROLLING and open the query with the INDEXED-REPOSITION option as the following syntax shows:
The DataServer enforces the ordering of the query according to the index that the Progress compiler chooses when processing the query. If the index is not unique, the table that you query must have a unique record identifier so that the DataServer can ensure that duplicates order predictably. The record identifier that the DataServer uses is the same one that supports the Progress ROWID function, that is, a PROGRESS_RECID column, the native ROWID, or a unique integer index. Performing an index reposition may cause the DataServer to issue a new query to ORACLE. This new result set may contain rows that were added or changed since the original query was ordered. Note, you can only scroll through the result set returned by the query. That is, you cannot scroll beyond the boundaries of the result set returned by the query. You cannot scroll through the rest of the database. Performing an index reposition may cause the DataServer to issue a new query to ORACLE. This new result set may contain rows that were added or changed since the original query was opened.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |