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 File-AID Selection Criteria screens.

Field Mask Criteria

image2021-3-19_14-30-23.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. This field cannot be overtyped, when you are on the Field Mask Criteria screen.

Mask Length

Length of the mask. This field may be overtyped 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.

The original format will be replaced by MASK on the Formatted Criteria and Selection criteria screens, when Field Mask is in effect.

Important

Field masking is not currently supported for bit, floating point, DBCS, 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.

CANCEL

Discards the entries.

 

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