Online Session › Additional Screens › Record/Element Review Screen › Example

Example

To have CA IDMS Extractor select records where the DEPT-ROOM-NO is not equal to zero:

1. Type 0 for all the field values for the DEPT-ROOM-NO field and press the EOF key.

   When values are entered in multiple fields, each field must satisfy the condition or database record is not extracted. In this example, DEPT-ROOM-NO(1) must be not=0 and DEPT-ROOM-NO(2) must be not=0, etc. for the database record to be extracted.

2. Type the END command or press the End PF key to save the criteria and return to the Field Level Selection Criteria screen.

   At this time, another criteria can be specified by selecting another operator and pressing the ENTER key again. In this situation, the database record would be extracted if its data satisfied either Criteria 1 or Criteria 2.