Changing data using the CHANGE command

Use the CHANGE primary command to search for a specified value or condition and change it to a new value. If File-AID finds a match, it changes the data to the new value that you specify. If you enter the CHANGE command without specifying any parameters, File-AID displays the CHANGE Command screen where you can enter your change parameters.

Initiate a Change - CHANGE Command With No Parameters

Steps:

1. Type CHANGE in the COMMAND field.
2. Press Enter. File-AID displays the CHANGE Command screen as shown in the following figure.

CHANGE Command Prompt Screen

Specifying the CHANGE parameters

Use the CHANGE Command prompt screen to enter your change criteria. Using this screen helps you to enter valid values and to learn about the CHANGE command syntax.

CHANGE Command Screen - CHANGE ALL INVALID to 0 (zero)

Steps:

1. Type INVALID in the "From string" field.

   Using the INVALID keyword in the "From string" field tells File-AID to search the specified field for data that does not match its field declaration in the record layout.

2. Type a 0 (zero) in the "To string" field.

   The value you enter in the "To string" field is the value that you want File-AID to substitute for the "From String" value. In this case, for any value that File-AID finds to be invalid.

3. Type ALL in the Modifier field.

   The ALL modifier tells File-AID to search all records for the condition you specified.

4. Type EMP-NATL-TAX-WITHOLD-PCT in the "Field name" field.

   This value tells File-AID which field in the layout to search for invalid values.

5. Press Enter. File-AID applies the CHANGE command as illustrated in the following figure.

CHANGE Result

After the CHANGE, File-AID displays record number 4 on the Edit screen with EMP-NATL-TAX-WITHOLD-PCT positioned at the top of the display and a value of 0 (zero) has replaced the invalid value. The cursor is placed on the new 0.

The message, EQ INVALID CHANGED, appears in the top right-hand corner of the display. Press PF1 (HELP) for details regarding the number of times File-AID applied the change you specified (message for this example: XVJFS410 FS410-/EMP-NATL-TAX-WITHOLD-PCT EQ INVALID - changed to 0 3 times on 3 record(s).).

Edit - CHANGE Result - INVALID Data In Record 4 Changed

More about the CHANGE command

You can specify the CHANGE command parameters on the CHANGE Command screen or specify the parameters with the CHANGE keyword in the COMMAND field.