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.
Note: For Teradata, the number specified here is used with
the Teradata SQL extension keyword SAMPLE in any SQL SELECT statement.
That information is used by the Teradata optimizer to identify the
maximum number of rows to be retrieved. For example, SAMPLE 100 in
a SELECT statement means the user wants up to 100 rows retrieved.
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.