Page Management

In the Query and Display section of the request is a field for specifying the size of a page of data. By default the page buffer in the File-AID Data Editor will hold 2,000 rows. This design allows you to work with very large data stores (relational database tables, MVS or z/OS UNIX files, or IMS databases) while providing rapid response.
When the number of selected rows of data in your data store exceeds the specified page size, page management is activated. To view a different page of rows than the rows initially presented, you must navigate using the page controls (image2021-8-18_12-50-38.pngandimage2021-8-18_12-51-24.png) at the top right of the display.
When working with a page, all rows in the page are relative to row 1 of the page, and there is no indication of the physical or relative row number in the data store.

Important

When working with relational databases and MVS data, Selection Criteria can be specified to isolate the specific rows you are interested in working with. Using selection criteria can reduce the need for page management. With IMS data, there is no selection criteria; instead, the Go To Segment by Key navigation function can reposition the page buffer to any point in the database.

Page Controls

Page controls are presented at the top right of the data display window.
image2021-8-18_12-52-24.pngIcons Means first page

image2021-8-18_12-50-38.pngMeans previous page

image2021-8-18_12-51-24.pngMeans next page

image2021-8-18_12-52-53.pngMeans last page.
The page controls are disabled unless the number of selected rows in your data store exceeds the size of your request for a page size.

Individual icons are disabled unless they are valid. Clicking on a page control icon will cause the current page to be saved and the new page to be displayed. For example if my page size is 2000 for a DB2 table with 10,000 rows, the first page displayed will show rows 1-2000 and have image2021-8-18_12-50-38.pngprevious page disabled, while the image2021-8-18_12-51-24.pngnext page and last page image2021-8-18_12-52-53.pngare enabled. When you click on the next pageimage2021-8-18_12-51-24.png , rows 2001-4000 will be displayed and all page controls will be active. Once you are displaying the last page in the data store, the next page image2021-8-18_12-51-24.pngand last pageimage2021-8-18_12-52-53.png become disabled.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*