Similar to RESTART-ROWID, the RESTART-ROW attribute of the Data-Source object facilitates batching when filling a ProDataSet temp-table. Unlike RESTART-ROWID, which repositions the query to a ROWID, this attribute allows the FILL query to be repositioned to an absolute row number.

For example, setting this attribute is helpful when you are paging back and forth in a table and want to retrieve page 3. BATCH-SIZE is used to calculate the row where a given page begins, and RESTART-ROW is set to that value just before the FILL. This causes the FILL query to be repositioned to the correct page. For example, to get page 3 you set RESTART-ROW to (3-1) * BATCH-SIZE to fill the third group of records.