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:

SYNTAX
DEFINE QUERY query FOR buf-name SCROLLING 

SYNTAX
OPEN QUERY query FOR EACH record-phrase INDEXED REPOSITION 

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