Selection criteria

The following figure is displayed when you enter the SELECT (SEL) primary command on any of the Data Solutions Formatted Criteria screens (Aging, Euro, Data Analyzer, Translator, Generator, Field Exit, and Encryption).

See Selection Criteria Options for a description of the Selection Criteria Options available through option 0 on the Change Criteria Menu. For more information, see Using Selection Criteria with Formatted Change Criteria.

Selection Criteria Screen

  Action Display Show Options Menu Help
-------------------------------------------------------------------------------
File-AID/Data Solutions ------- Selection Criteria ----------------------------
COMMAND ===>                                                  SCROLL ===> PAGE

SET 1 OF 1           EMPLOYEE-MASTER-FILE              LAYOUT LENGTH:     198
---- FIELD LEVEL/NAME ------- -FORMAT- RO ----+----1----+----2----+----3----+--
******************************* TOP OF DATA ***********************************
5 EMP-NUMBER                    5/AN
5 EMP-LAST-NAME                15/AN
5 EMP-FIRST-NAME               10/AN
5 EMP-MID-INIT                  1/AN
5 FILLER                        2/AN
5 EMP-TITLE                    30/AN
5 EMP-PERSONAL-INFO SYNC       23/GRP
   10 EMP-NATL-ID-NUMBER         9/NUM
   10 FILLER                     1/AN
   10 EMP-DATE-OF-BIRTH          6/AN
   10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH
   10 EMP-DOB-REDEF SYNC         6/GRP
     15 EMP-DOB-MM               2/NUM
     15 EMP-DOB-DD               2/NUM
     15 EMP-DOB-YY               2/NUM
Use RO = FM for Field Mask. VIEW command to browse criteria. END to process.

Field Descriptions

Specify a relational operator. See the following table for possible values.

Relational Operators

EQ, =	Equal to
NE, Ø=, !=	Not equal to
GT, >	Greater than
GE, >=	Greater than or equal to
LT, <	Less than
LE, <=	Less than or equal to
CO	Contains; scans the specified field for the presence of a data value. CO works on an equal condition. See also Note 1.
NC	Not contains; scans the specified field for the absence of a data value. NC works on a not equal condition. See also Note 1.
BT	Between; within a range of two values (endpoints inclusive). The value is greater than or equal to the first endpoint and less than or equal to the last endpoint.
NB	Not between; outside a range of two values (endpoints exclusive). The value is less than the first endpoint or greater than the last endpoint.
VA	Valid character, text, numeric, or packed data based on the field format. See also Note 2.
NV	Not valid character, text, numeric, or packed data based on the field format. See also Note 2.
VU	Valid unsigned display numeric data based on the specified data type where the last digit must not contain a sign. VU operator will treat character and text as numeric. VU cannot be used on packed data. See also Note 2.
NU	Not valid unsigned display numeric data based on the specified data type where the last digit must not contain a sign. NU operator will treat character and text as numeric. NU cannot be used on packed data. See also Note 2.
MX	Bits are mixed, ones and zeros (Mask data value only).
NO	Bits are not ones (Mask data value only).
FM	Field mask. For more information, see Field Mask.
FF	Field-to-Field operation. For more information, see Field-to-Field Criteria.
DF	Disguise failed. Change criteria in the specified set is to be processed, if the preceding non-data translation set failed. Not valid on a subscripted field. If disguise failed on a subscripted field, type DF in the RO column next to any field other than a subscripted field. Use like TF for non-data translation; For an example of how to use TF, see Defining Your Third Criteria Set.
TF	Translation failed. Change criteria in the specified set is to be processed, if the preceding data translation set failed to find a search or key value. Not valid on a subscripted field. If data translation failed on a subscripted field, type TF in the RO column next to any field other than a subscripted field. For an example of how to use TF, see Defining Your Third Criteria Set.

Important

The CO and NC relational operators can be specified only for alphanumeric fields (PIC X for COBOL; CHAR or PIC X for PL/I).
VA, NV, VU, and NU operators will treat character and text as numeric.
File-AID/Data Solutions or File-AID/MVS do not currently support selection criteria that use bit or numeric fields that specify a leading and/or separate sign.
File-AID/Data Solutions or File-AID/MVS do not currently support field masking that use bit, floating point, DBCS, or numeric fields specifying a leading and/or separate sign.

data value

For fields with relational operators other than BT and NB, you specify the field value to use in the comparison in alphanumeric format and File-AID/Data Solutions converts it to the correct data type format (as in File-AID/MVS Edit formatted mode). For relational operators BT and NB, specify your Data Value as two values separated by a colon (:). The values may be hex strings, character strings, or numeric tests.

To compare an alphanumeric field to blanks (hexadecimal 40s), leave the data value column blank.

Operator Validity by Data Type

The following table shows the valid operators that may be used with each of the seven data types:

Operator Validity by Data Type

Data Type	Valid Operators
T (Text - any case)	EQ	NE	GE	GT	LE	LT	CO	NC	BT	NB	VA	NV	VU	NU	FM	DF	TF	FF
C (Character - exact case)	EQ	NE	GE	GT	LE	LT	CO	NC	BT	NB	VA	NV	VU	NU	FM	DF	TF	FF
X (Hex)	EQ	NE	GE	GT	LE	LT	CO	NC	BT	NB						DF	TF	FF
P (Packed)	EQ	NE	GE	GT	LE	LT			BT	NB	VA	NV			FM	DF	TF	FF
N (Numeric - zoned)	EQ	NE	GE	GT	LE	LT			BT	NB	VA	NV	VU	NU	FM	DF	TF	FF
B (Binary)	EQ	NE	GE	GT	LE	LT	CO	NC	BT	NB	VA	NV	VU	NU	FM	DF	TF	FF
M (Mask byte)	EQ	NE																FF	NO	MX

Selection criteria

Field Descriptions

Operator Validity by Data Type

On this page