Narrow the Focus

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

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:

Columns
Select columns from the Start Table to display for Point and Shoot. Point and Shoot allows you to extract specific rows from the Start Table.
Selection Criteria
Specify selection criteria for any column in a selected table. Choose AND or OR to combine selection criteria, as required.
SQL
Select SQL to view a list of valid logical or relational operators and define a detailed SQL Where clause as selection criteria. Use this option when multiple conditions are required.
Sort
Sort columns in the Start Table to display for Point and Shoot.
File Attachments
Specify parameters to extract a file referenced within or associated with a row of extracted data and include it in an Extract File.

For this scenario, Table Specifications are not used. For complete information about Table Specifications, see the Common Elements Manual.

Reference Table

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.

Extract Parms

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:

Every Nth
Enter a numerical value “N” under this heading to extract every Nth row of the corresponding table.
Row Limit
Specify the maximum number of rows to extract from a table.

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.

Access Definition Editor setup to extract every tenth row in the CUSTOMERS table