To narrow the focus of the Access Definition, you can define limits and selection criteria. Move provides several methods to limit the scope of the extracted data.
Table specifications provide the display and criteria parameters for data. You can set specifications for any table in the Table List by clicking right mouse button on the table name and selecting a Table Specifications option from the shortcut menu. A brief description of each option follows:
For this scenario, Table Specifications are not used. For complete information about Table Specifications, see the Common Elements Manual.
Under the heading Ref Tbl, you can select a check box to designate a table as a Reference Table. Unless selection criteria are specified for the Reference Table, all rows are selected from the table. The Start Table cannot be a Reference Table. For this scenario, designate ITEMS as a Reference Table.
Under the heading Extract Parms on the Table List, you can enter values under the following subheadings to limit the number of rows to extract:
For this scenario, extract a sampling of the CUSTOMERS rows. Type the number “10” in Every Nth for the CUSTOMERS table to select every tenth row. Leave the Row Limit blank.