Allows the FILL query to be repositioned to an absolute row number. Similar to RESTART-ROWID, this attribute facilitates batching during a FILL on a ProDataSet temp-table.
Setting this attribute is helpful when you are paging back and forth in a table and want to retrieve, for example, page 3. The
BATCH-SIZE attribute 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.
An integer expression indicating the absolute row number to reposition the query.