Defining the formatted layout selection condition


Field number 5, the ORDER-TYPE field, is located in column 11 of each data record. When the ORDER-TYPE field in a data record is equal to "PO" this ORDERPO member is to be used to format the data.

Steps:

  1. Type END in the COMMAND field.
  2. Type EQ (equal) in the RO column to the right of the ORDER-TYPE field.
  3. Type PO in the data value area to the right of the RO column for the ORDER-TYPE field.
  4. Press Enter. File-AID captures your condition and returns to the Define XREF screen, as illustrated in Define XREF Screen (SU Command). Selecting Unformatted Criteria.

Formatted XREF Definition. Specifying the Selection Condition.

image2021-6-21_19-16-53.png

More About the Formatted XREF Definition Screen

  • Valid RO operators include: BT, EQ, GE, GT, LE, LT, NB, NE.
  • The following codes are not allowed when defining an XREF: CO, NC, MX and NO.
  • You can specify multiple fields; the field tests are ANDed together.
  • Use the INSERT or REPEAT command to enter alternate conditions (sets) for selecting a layout. Each CRITERIA set is ORed to all others. A record matching any CRITERIA set causes the current layout to be selected for formatting data.
  • Use DELETE to remove a condition. Removing the last criteria condition makes this layout a DEFAULT-BASE.

 

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