Formatted Selection Criteria
The following figure allows you to specify selection of records based on field values displayed with a record layout. This screen is similar to the Edit formatted mode screen except that the Formatted Selection Criteria screen has an additional column, RO (Relational Operator), located to the right of the FORMAT column which does not display record data.
Select option 2 on the Selection Criteria Menu to display the Formatted Selection Criteria screen. If you did not specify a record layout or XREF dataset prior to selecting option 2, File-AID displays the Record Layout Specification screen, shown in Unformatted Selection Criteria Example, for entry of the required information.
Formatted Selection Criteria screen
COMMAND ===> SCROLL ===> CSR
SET 1 OF 1 INVENTORY-RECORD GBL = N
---- FIELD LEVEL/NAME ------- -FORMAT- RO ----+----1----+----2----+----3----+--
******************************* TOP OF DATA ***********************************
5 INV-PART-NO 15/AN
5 INV-DESCRIPTION 40/AN
(POS 38-40)
5 INV-UNIT-OF-MEASURE 2/AN
5 INV-UNIT-PRICE 4/PS
5 INV-STOCK-INFO(ANY) OCCURS 2 TIMES
18/GRP
10 INV-WAREHOUSE(ANY) 3/AN
10 INV-STATUS(ANY) 6/AN
10 INV-QTY-DATE(ANY) 9/GRP
15 INV-QTY-ON-HAND(ANY) 3/PS
15 INV-LAST-ORDER-DATE(ANY)
6/AN
10 INV-BO-QTY-DATE REDEFINES INV-QTY-DATE
10 INV-BO-QTY-DATE(ANY) 9/GRP
15 INV-QTY-BACKORDERED(ANY)
Valid RO: EQ,NE,GT,GE,LT,LE,CO,NC,BT,NB,VA,NV,VU,NU,MX,NO,FM,FF
Commands: View
Field Descriptions
RO
Specify a relational operator. See the following table for possible values.
Relational Operators
Relational Operator | Description |
|---|---|
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. |
NC | Not contains; scans the specified field for the absence of a data value. NC works on a not equal condition. |
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 specified data type. VA operator will treat character and text as numeric. |
NV | Not valid character, text, numeric, or packed data based on the specified data type. NV operator will treat character and text as numeric. |
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. |
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. |
NO | Bits are not ones (Mask data value only). |
MX | Bits are mixed, ones and zeros (Mask data value only). |
FM | Field mask. See Field Mask for more information. |
FF | Field-to-Field operation. See Field-to-Field Criteria for more information. |
File-AID is distributed with a default value of EQ (equal) for relational operator. The default value can be modified with File-AID option 0.2 Selection Criteria Parameters screen. See Selection Parameters.
data value
For fields with relational operators other than BT and NB, you specify the field value to use in the comparison exactly as in 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.
This section provides information about the following topics: