<< Click to Display Table of Contents >> Navigation:  System Manager > Utilities > UT-K-B Global Field Replace

UT-K-B  Global Field Replace

Purpose of Program

Use this program to globally change the value of a given field within a file or delete entries across all records within a file based on up to 6 filters using other fields within the 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.

Choose an action - Replace (update a field value to a new value), Adjust (increment a numeric field by a flat amount or percent) or Delete (Delete the entire record, not clear a value in a field.)

If you chose Replace or Adjust, 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 brackets 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 Item master file (MTICMSTR) the Standard cost field MTIC.PROD.RCOST consists of fifteen array elements representing the various component s of standard cost.

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

For REPLACE Action

Enter the new value that will replace existing values in the Replace with value field.

 

For ADJUST Action

Enter the adjustment value

 

For all actions, next enter the filters on the selected or other fields in the file that control which records should be updated.  Available operators are =, <, <=, >, >=,All and $ which means "Contains Substring"

 

Enter up to 6 filters and if entering fewer than 6, make sure you have fully entered the last filter and the cursor is on the next line ready to enter the next filter.  Then press F10 to begin processing.  When the processing is complete, you will be advised of the number of records affected.