Changing Field Selection Criteria

To edit an existing field criteria subset, type E against the field criteria subset. FM/IMS displays the Segment Selection panel for the criteria subset. To create a new field criteria subset, type I against any of the criteria subsets. FM/IMS displays the Segment Selection panel for the new criteria subset. From the Segment Selection panel, you are able to determine the segments FM/IMS extracts. If you were to change this in one criteria subset then this changes the segments to be extracted for all FM/IMS criteria subsets in this criteria set.

Also, from this panel you are able to maintain the Field Selection Criteria to determine what database records are extracted. If you have multiple criteria subsets, FM/IMS extracts the data matching each of the criteria subsets and then sorts the data to remove duplicate records.

  1. Type E against an IMS segment.
  2. Press Enter.

FM/IMS displays the selection:

  • Criteria Segment Layout Selection panel (if segment contains multiple layouts).
  • Criteria Segment Layout panel (if segment contains a single layout).

FM/IMS displays the Criteria Segment Layout panel, if the segment contains multiple layouts for the segments. FM/IMS allows you to place Field Selection criteria against each individual layout. For example, if the suburb segment had the city and country layouts, it is possible to only extract city suburbs starting with F and country suburbs starting with S.

  1. Type E against the segment layout on the Segment Layout Selection panel, or against an IMS segment with a single layout on the Criteria Specification panel.
  2. Press Enter.

From the Criteria Segment Layout panel, you are able to enter field selection criteria to be used to extract an IMS segment matching the criteria (if single layout) or an IMS segment using the required layout with criteria which matches the segment that has been specified for each layout (multiple layouts).

When extracting data, FM/IMS matches all data for segments and layouts for each criteria subset to determine if the database record (Root + dependants) is to be extracted or an IMS segment which matches the criteria specified for the layout and uses the particular layout. If any criteria fail, FM/IMS does not extract the database record. Multiple criteria subsets can be used to extract database records with different criteria.

Criteria 1
Extract segments starting with S that contain the STREET CANNING HWY.
Criteria 2
Extract segments with POSTCODE > 6550 and have STREET VICTORIA PARK.