User Views › Object Menu Bar › View Menu › Defining a Filter › Field to Field Comparisons

Field to Field Comparisons

A field within a table row can be compared to any other field in the row according to the following rules. If the following field-to-field compatibility rules are violated, you will receive an error message when using the filter dialog.

• The INCL and EXCL operators cannot be used.
• Any Character, Text, or Flag field can be compared to any other Character, Text or Flag field. The comparison is not case sensitive (case is ignored).
• Any Numeric field can be compared to any other Numeric field.
• Any Date field can be compared to any other Date field (except field types DJPU and DJIU, which can only be compared to another DJPU or DJIU field respectively - because they may not be real dates).
• Any Time field can be compared to any other Time field.
• A Hex field can be compared to another Hex field ONLY if they have the same length.

Examples of field-to-field comparison filter statements

The following field-to-field comparison filter statement, for the Data Sets For System (All) object, identifies data sets that were created but have not been used since the creation date.

Create Dt = LastUseDt

This could be expanded to list only data sets that were created and last used on the same date, but in addition, have not been used within the last 100 days. This combined test eliminates displaying recently created data sets:

Create Dt = LastUseDt AND DaysUn > 100 

Another example of a field-to-field comparison filter statement using the Data Sets For System (All) object, is to compare the logical record length value and the block size value. The result is a list of data set names where logical record length is the same as the block size. The results can indicate poorly blocked data sets.

Lrecl =  Blksz