Field Selection Criteria panel

Panel and field definitions

  Process   Options   Help
 ───────────────────────────────────────────────────────────────────────────────
 FM/IMS               Field Selection Criteria                      Line 1 of 5

 Cmd Con ( Field Name                          Op  Value                       )
     <-> - <---+----1----+----2----+----3----> <-> <---+----1----+----2----+-- -
 *** ****  Top of data  ****
           SUBURB-STREET                                                        
     AND   SUB-STREET-KEY                                                       
     AND   SUB-STREET-NAME                                                      
     AND   SUFFIX                                                               
     AND   DIRECTION                                                            
*** ****  End of data  ****








 Command ===>                                                       Scroll HALF
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F5=RFind     F6=RunTemp
  F7=Up        F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel    

Cmd

Prefix command area. These editor prefix commands are allowed: A, B, C, Cn, CC, D, Dn, DD, M, Mn, MM, O, On, OO, R, Rn, RR and RRn.

Con

Connectors - used to specify the AND/OR connectors. These are only relevant to lines containing segment selection expressions. The default value is AND. You can overtype the connectors with any of the following values:

Value entered

Resultant value

AND

AND

&

AND

OR

OR

|

OR

Note: Abbreviations are accepted. For example, if you overtype AND with O, it is changed to OR.

(

Left Parenthesis - parentheses must only be used on lines containing expressions. They are used to group criteria. The number of left parentheses must match the number of right parentheses.

Field Name

A non-editable field that displays the field names defined in the original copybook.

Note: If you are running a screen width of 115 or greater, the Field Name field can be displayed at the same time as the Start, Length and Type fields. However, at any width less than this, you need to toggle the display between Field Name and Start, Length and Type. The default display is Field Name. To toggle the display, enter the FLDNAME command or press F11.

Start

A non-editable field that displays the starting location of the fields, as defined in the original copybook.

Length

A non-editable field that displays the length of the fields, as defined in the original copybook.

Type

A non-editable field that displays the data type of the fields, as defined in the original copybook.

Op

Operator - used to create expressions. Valid operators are:

=, EQ

True if the terms are equal (numerically or when padded)

\=, ¬=, /=, NE

True if the terms are not equal (inverse of =)

>, GT

Greater than

<, LT

Less than

><, <>

Greater than or less than (same as not equal)

>=, GE

Greater than or equal to

\<, ¬<

Not less than

<=, LE

Less than or equal to

\>, ¬>

Not greater than

==

True if terms are strictly equal (identical)

\==, ¬==, /==

True if the terms are NOT strictly equal (inverse of ==)

>>

Strictly greater than

<<

Strictly less than

>>=

Strictly greater than or equal to

\<<, ¬<<

Strictly NOT less than

<<=

Strictly less than or equal to

RG

Range - value1 >= field <= value2

NR

Not in range - field < value1 or field > value2

CO

Contains one of the values specified

¬CO

Does not contain one of the values specified.

NC

Numeric contains - a number is one of the values

¬NC

Does not contain the specified number(s)

Value

Use this field to provide a character or numeric constant to be used for comparison in the expression. If the operator supports more than one value (for example, RG, CO) then use comma delimiters to provide separate values. When specifying values, the following rules apply:

Hexadecimal strings

A hexadecimal string must be in the form 'hhhhhh'x. The value enclosed in quotation marks must be an even number of characters and contain valid hexadecimal characters (0123456789ABCDEF).

Binary strings

A binary string must be in the form 'nnnnnn'b. The value enclosed in quotation marks must be a combination of 0 and 1s.

Numeric Operands

The value(s) specified for a numeric field type must be a valid number. Quoted values are not accepted.

Character strings

For nonnumeric types the value is automatically enclosed in quotation marks if you do not specify them. When specifying more than one value for operations other than RG and NR you must provide quotation marks for all the comma delimited values

Date strings

A date string must be in the form d’xxxxxxxx’. The string must be specified in the output format defined for the field.

The following is an example of a date value:

    d'Jan 01, 2014'

where the output format is:

    Mmm DD, YYYY

Time strings

A time string must be in the form t’xxxxxxxx’. The string must be specified in the output format defined for the field.

The following is an example of a time value:

    t'15:30:00.000'

where the output format is:

    HH:MI:SS.999

Note:

1. Date and time strings cannot be used with contains operators.
2. When used with range operators requiring two values the second value should be quoted, for example, d'Jan 01, 2014','Dec 01, 2014'.
3. Use d'=' or t'=' to retrieve the current date or time value in the output format.

)

Right Parenthesis - parentheses must only be used on lines containing expressions. They are used to group criteria. The number of left parentheses must match the number of right parentheses.