Sample selection sets


Formatted Selection Criteria Example (Page 1)

File-AID --- Formatted Selection Criteria -------------------------------------
COMMAND ===>                                                  SCROLL ===> CSR
   SET:  1 OF  2         EXAMPLE-FILE                           GBL = N
---- FIELD LEVEL/NAME ------- -FORMAT- RO ----+----1----+----2----+----3----+-
******************************* TOP OF DATA ********************************
5 FIELD-ONE                     1/AN   =  A,B,C
5 FIELD-TWO                     1/AN   =  D
5 FIELD-THREE                   1/AN
***************************** BOTTOM OF DATA *******************************

Formatted Selection Criteria Example (Page 2)

File-AID --- Formatted Selection Criteria -------------------------------------
COMMAND ===>                                                  SCROLL ===> CSR
   SET:  2 OF  2         EXAMPLE-FILE                           GBL = N
---- FIELD LEVEL/NAME ------- -FORMAT- RO ----+----1----+----2----+----3----+-
******************************* TOP OF DATA ********************************
5 FIELD-ONE                     1/AN
5 FIELD-TWO                     1/AN
5 FIELD-THREE                   1/AN   =  E
***************************** BOTTOM OF DATA *******************************

Unformatted Selection Criteria Example

File-AID -------------  Unformatted Selection Criteria  ---  ROW 1 TO 16 OF 25
COMMAND ===>                                                  SCROLL ===> CSR  

Use END to continue, CANCEL to return to main screen.  

    AND
Cmd /OR Position Length RO                      Data Value
--- --- -------- ------ -- ----------------------------------------------------
___      1              EQ T'a,b,c'
___ AND  2              EQ T'd'
___ OR   3              EQ T'e'
___ AND  _____   _____  EQ ____________________________________________________
___ AND  _____   _____  EQ ____________________________________________________

The formatted conditions specified in Formatted Selection Criteria Example (Page 1)Formatted Selection Criteria Example (Page 2) and the unformatted conditions specified in Unformatted Selection Criteria Example both translate into the following expression:

  If ((A or B or C) and D) or E

which can also be stated as:

  If (A and D) or (B and D) or (C and D) or E.

Primary Commands

The following is a list of the primary commands that are valid on the Formatted Selection Criteria screen. Each command is discussed in Primary-commands.

ALIGN (AL)

Controls display of ALIGNED/UNALIGNED term for PL/I data.

ARRAY (AR)

Controls display of array declaration information for PL/I data.

ON

Displays an array definition line for each subscripted item in a record layout.

OFF

Does not display an array definition line.

ALL

Displays all occurrences separately with the subscript(s) and any criteria entered on a specific occurrence will only be applied to that occurrence. This additional parameter is only valid during Formatted Selection Criteria creation.

ANY

Displays a single entry for the occurrences and any criteria entered for the ANY occurrence will be applied to all occurrences. The record will meet the Selection Criteria if any of the occurrences meet the specified criteria. This additional parameter is only valid during Formatted Selection Criteria creation. ANY is applied for initial display of Selection Criteria.

Important

When applying 2 or more criteria in the same subset, all have to be true in the same occurrence to be selected.
When entered individually in different subsets, they don’t have to be true in the same occurrence to be selected.

EVERY

Displays a single entry for the occurrences and any criteria entered for the EVERY occurrence will be applied to all occurrences. The record will meet the Selection Criteria if all of the occurrences meet the specified criteria. This additional parameter is only valid during Formatted Selection Criteria creation.

Guidelines

  • Use the PROFILE command to display the current ARRAY ON or OFF value. Only ON or OFF are saved in the profile.
  • The array line contains the name of the array followed by the word ARRAY and the subscript bounds in standard PL/I format. If any of the subscripts are defined by a REFER clause, additional lines that follow the ARRAY line describe each REFER variable.
  • ANY, EVERY and ALL are available only in Formatted Selection Criteria.
  • ANY, EVERY or ALL is applied per set or subset if any. Each set or subset may have a different array setting.
  • You cannot switch ANY, EVERY or ALL to another if the criteria is specified on any occurrence field in a single set or single subset.
  • In ANY or EVERY mode, the SHOW OFFSET command shows the offsets of the first occurrence.

BACK

Positions the display to the previous criteria. Synonym for LEFT.

CANCEL (CAN)

Returns to main panel without saving current updates.

CAPS

Sets caps mode. CAPS ON is not case-sensitive in the search to match the selection criteria. Specify CAPS OFF for a case-sensitive search. This command is valid only on a new criteria display.

COMPLEX (CMPLX)

Controls display of COMPLEX terms for PL/I data.

DELETE (DEL, D)

Delete a selection set or subset.

DISPLAY (DIS)

Specifies a display format.

MAXREFER

(for PL/I layouts only) Specify the maximum number of occurrences to display. Omission of the DISPLAY MAXREFER command causes PL/I Refers to default to 1 occurrence. See also DISPLAY-MAXREFER-DIS-MAXREFER.

DOWN

Scrolls down.

END (E)

Terminates display of the Formatted Selection Criteria screen and returns to the Selection Criteria Menu.

FILLER (FILL)

Controls display of FILLER fields.

FORWARD (FWD)

Positions the display to the next criteria. Synonym for RIGHT.

GLOBAL (GBL)

Displays the GLOBAL Selection Criteria panel (Global Selection Criteria) which shows the defined global fields (variables). Use this panel to create criteria which will test values of global fields. Valid only if a global field has been defined.

On the GLOBAL Selection Criteria panel, you enter selection criteria in the same way you enter selection criteria on the record layout; the normal relational operators are available to operate against the global variables.

GROUP

Controls the display of occurrences of group-level items.

INPUT/ INSERT (I)

Inputs/inserts a new formatted selection criteria set.

AND

Inserts an ANDed subset of selection criteria (the set counter displays “AND Set 1.2 of 1”) after (default) or before the current criteria. See also INPUT-INSERT-I-Selection-Criteria.

LEFT (L)

Positions the display to the previous criteria. Synonym for BACK.

LOCATE (LOC)

Scrolls directly to the specified record layout line.

LR (Locate Record)

Positions the display to the specified criteria number.

MESSAGE (MSG)

Controls the message display.

OCCURS (OCC)

Controls the display of array declaration items.

ON

Displays an array definition line for each subscripted item in a record layout.

OFF

Does not display an array definition line.

ALL

Displays all occurrences separately with the subscript(s) and any criteria entered on a specific occurrence will only be applied to that occurrence. This additional parameter is only valid during Formatted Selection Criteria creation.

ANY

Displays a single entry for the occurrences and any criteria entered for the ANY occurrence will be applied to all occurrences. The record will meet the Selection Criteria if any of the occurrences meet the specified criteria. This additional parameter is only valid during Formatted Selection Criteria creation. ANY is applied for initial display of Selection Criteria.

Important

When applying 2 or more criteria in the same subset, all have to be true in the same occurrence to be selected.
When entered individually in different subsets, they don’t have to be true in the same occurrence to be selected.

EVERY

Displays a single entry for the occurrences and any criteria entered for the EVERY occurrence will be applied to all occurrences. The record will meet the Selection Criteria if all of the occurrences meet the specified criteria. This additional parameter is only valid during Formatted Selection Criteria creation.

Guidelines

  • Use the PROFILE command to display the current OCCURS ON or OFF value. Only ON or OFF are saved in the profile.
  • The OCCURS line contains the name of the array followed by the word OCCURS and the subscript bounds in standard COBOL format. If any of the subscripts are defined by a REFER clause, additional lines that follow the ARRAY line describe each REFER variable.
  • ANY, EVERY and ALL are available only in Formatted Selection Criteria.
  • ANY, EVERY or ALL is applied per set or subset if any. Each set or subset may have a different array setting.
  • You cannot switch ANY, EVERY or ALL to another if the criteria is specified on any occurrence field in a single set or single subset.
  • In ANY or EVERY mode, the SHOW OFFSET command shows the offsets of the first occurrence.

OFFSET

Displays field offsets.

OPT (O, 1)

Displays the Selection Criteria Options screen.

PROFILE (PROF)

Displays profile information lines.

REDEFINE (REDEF, REF)

Controls the display of data item redefinitions.

REFLNG

Controls the display of BIT/CHAR REFER field length reference lines for PL/I data.

REPEAT (R)

Causes a formatted selection criteria set, including any subsets, to be repeated (SET 3 of 3 increments to SET 4 of 4; AND SET 3.2 of 3 increases to AND SET 4.2 of 4).

AND

Repeats an ANDed subset of selection criteria. (the set counter displays “AND Set 1.2 of 1”) after the current criteria. See also REPEAT-REP-R-Selection-Criteria.

RESET (RES)

Causes excluded lines to be redisplayed.

RETURN

Returns to the Primary Option Menu.

RIGHT

Positions the display to the next criteria. Synonym for FORWARD.

SAVE

Saves the displayed selection criteria.

SHOW (SH)

Displays LEVEL, NUMBER, FORMAT, OFFSET, or PICTURE information for the selection fields.

SYNC

Controls the display of the SYNC term for fields in a COBOL record layout.

UNFMT (U, 3)

Displays the Unformatted Selection Criteria screen.

UP

Scrolls up.

USE

Specifies another record layout for the current formatted selection criteria.

VIEW (V)

Displays the View Criteria screen which is a keyword summary of the current settings for options, global variables, formatted, and unformatted selection criteria. See View Criteria Screen.

ZERO (Z)

Controls the display of leading zeros in the numeric data fields.

 

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