UT-K-B  Global Field Replace

Purpose of Program

Use this program to globally change the value of a given field within a file across all records within that file.

General Program Operation

MAKE A BACKUP FIRST.  This is a utility program that will affect many data records.  With a backup you can always restore the data if for any reason the program does not produce the desired results.

GET EVERYONE OFF THE SYSTEM: Get all users off the system before running this program.

Enter the File Name.  You can select a file from a lookup by clicking on the Display Files button or (or press F2).  See File Names for a listing of file names and descriptions.

A lookup window automatically displays with a list of all the available fields within this file.  Select the field you wish to change by highlighting it, then click on it or press <Enter>.  The field name is now displayed in the Field name picked field.

If the field had a number in parenthesis to the right of the field name when displayed in the lookup window, this means the field is an array.  An array means that the field is composed of several elements.  For example, in the Customer master file (BKARCUST) the Contact field consists of five array elements representing Contacts 1-5 on the AR-A Enter Customers contacts screen.

If the field is an array field, enter the array element to be changed in the Array element number field.

In the Enter value to replace field you can specify a specific value to look for so that the program will only replace fields with that value.  If you leave the field blank, ALL field values will be replaced, no matter what they are.  If you leave the field blank you will be asked to confirm that you want to replace all field values.

Finally, enter the new value that will replace existing values in the Replace with value field.  Once you press <Enter> at the completion of this field, the program will begin processing.