Field mask


The following figure is displayed when you enter the Field Mask (FM) relational operator in the relational operator (RO) column on any of the Data Solutions Formatted Criteria (Date Aging, Euro, Data Analyzer, Translator, Generator, Field Exit, and Encryption) and Selection Criteria screens.

Field Mask Screen

image2021-9-9_16-33-10.png

Important

To ensure accurate Field Mask processing, the Field Mask (FM) relational operator must be entered prior to entering any other relational operators.

Field Descriptions

Field Name

Name of the selected field as defined by the record layout.

Data Type

Data type of selected field as defined by the record layout.

Field Length

Length of data in selected field as defined by the record layout. You cannot type over this field, when you are on the Field Mask Criteria screen.

Mask Length

Length of the mask. You may type over this field to shorten or lengthen the length of the data to be masked. This is particularly useful when you want to mask all the elements of a group item.

Important

You cannot override Mask Length for binary or packed/comp-3 fields.

Identify field positions to process: (Y = include; N = exclude)

Field Mask

A Field Mask enables processing of selected positions or part of a field. It always operates on character representation of the field. Specify Y or N to include or exclude field positions to be processed for masking.

Field Mask can be applied to both numeric and character fields.

Each mask position corresponds to a digit in the decimal value of the original field, when masking numeric fields. The selected digits are passed as a single unsigned numeric display field for the specified product function.

Important

Signs (+,-) are excluded when masking numeric fields.

When masking character fields, each mask position corresponds to the identical position in the original field. The selected positions are passed as a single contiguous character field.

Unselected field positions retain their original value during masking.

The original format will be replaced by MASK on the Formatted Criteria and Selection criteria screens, when Field Mask is in effect. A ** Field Mask in Effect ** comment displays on the Field Parameters and Criteria screens, after a Field Mask is applied and an appropriate relational operator is entered on the Data Translator and Data Generator Criteria screens respectively.

Important

Field masking is not currently supported for bit, floating point, variable length character, variable length graphics, or numeric fields that specify a leading and/or separate sign.

Primary commands

The following primary commands are valid:

END

Saves the entered field mask parameters and returns to the formatted Criteria screen.

CANCEL

Discards the entries and returns to the formatted Criteria screen.

 

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