How to run the mass update utility

About this task

If you need to make many updates to application or job descriptions, consider using the mass update function to perform the updates to the database in batch. Perform mass updates in trial mode first. Trial mode produces a report from which you can verify the proposed changes before submitting the request in update mode, which implements the changes in the application description database.

This example shows how you might use the panel to change the priority of all Paymore applications (which have an OWNER ID of SAMPLE) from priority 5 to priority 4, or simply make a list of applications that have priority 5:

Select option 5 from the MAINTAINING APPLICATION DESCRIPTIONS or MAINTAINING JOB DESCRIPTIONS menu to display the panel in EQQAUPDL - Mass updating of application description.

Figure 1. EQQAUPDL - Mass updating of application description

EQQAUPDL --------- MASS UPDATING OF APPLICATION DESCRIPTION  ROW 1 TO 10 OF 54
 Command ===>                                                  Scroll ===> CSR

 Enter the row command S to create pending updates for a data item.
 Enter the CLEAR command above to delete all pending updates.

 Number of pending updates in this session: 0

 TYPE OF BATCH JOB  ===> _           T - Trial run, U - Updating run

 Row
 cmd Data item
 '   GEN - APPLICATION TEXT
 '   GEN - OWNER ID
 '   GEN - OWNER TEXT
 s   GEN - PRIORITY
 '   GEN - AUTHORITY GROUP ID
 '   GEN - CALENDAR ID
 '   GEN - APPLICATION GROUP ID
 '   RUN - TEXT
 '   RUN - PERIOD NAME
 '   RUN - RULE NAME

Enter the CLEAR command on the command line to delete pending updates that you no longer need.
Scroll down through the list of items that can be modified using the mass update function. You can update these data items:

GEN

General information

RUN

Run cycle definitions

OPR

Operation data

INT

Internal predecessors

EXT

External predecessors

Type s beside GEN – PRIORITY and press Enter. The UPDATING DATA ITEM panel, shown in EQQAUUGL - Updating data item, is displayed:

Figure 2. EQQAUUGL - Updating data item

EQQAUUGL -------------------- UPDATING DATA ITEM ------------  ROW 1 TO 1 OF 1
Command ===>                                                  Scroll ===> PAGE

Enter/Change data in the rows, and/or enter any of the following
row commands:
I(nn) - Insert, R(nn),RR(nn) - Repeat, D(nn),DD - Delete
S - Specify filter criteria

Updating data item     : GEN - PRIORITY
Maximal data length    : 1
Valid data             : A digit 1 to 9

Row  Target
cmd  criteria
s''          Old data: _________________________________________________
             New data: _________________________________________________

******************************* BOTTOM OF DATA **************************

Enter the S row command to select a subset of applications. The SPECIFYING FILTER CRITERIA panel, shown in EQQAUFIP - Specifying filter criteria, is displayed:

Figure 3. EQQAUFIP - Specifying filter criteria

EQQAUFIP ---------------- SPECIFYING FILTER CRITERIA --------------------
Command ===>

Specify filter criteria below:

OWNER ID           ===> sample__________
                                    Restrict the updating of applications to
                                    applications with a certain owner.
Enter data in one
of these fields only:
 PERIOD/RULE NAME  ===> ________    Restrict the updating of runcycles to
                                    runcycles with a certain period name.

 JOB NAME          ===> ________    Restrict the updating of operations to
                                    operations with a certain job name.

 WORK STATION NAME ===> ____        Restrict the updating of operations to
                                    operations with a certain work station
                                    name.

Type sample in the OWNER ID field. You can also use global search characters to limit the scope of a change, typing sam*, for example, for all IDs beginning with SAM. Press PF3 (End) to return to the UPDATING DATA ITEM panel. You now see the word Filter in the Target criteria column.
Enter 5 in the Old data field and 4 in the New data field:
```
Row  Target
cmd  criteria
 '' Filter   Old data: 5
              New data: 4
```
If you specify no old data value, all applications matching the filtering criteria that have the field defined are changed to the new data value. For example, if you specify a new value of NEW.RESOURCE for a resource name, and leave the old value blank, any operation with a resource defined will be updated with the new resource name: operations that did not originally have a resource defined remain unchanged.
Note: If the old data string is found anywhere in the target field data, it is replaced by the new data string. If the new data string is longer than the old data string, the target field can be truncated, as shown in this example:

Before the mass update:
The target field is 8 bytes long.
Three instances of the target field contain PAYUPD, PAYUPDAT, and UPDATE.
Old data is UPD.
New data is BKUP.
After the mass update:
The updated fields contain PAYBKUP, PAYBKUPA, and BKUPATE respectively.
Press PF3 (End). You return to the MASS UPDATING OF APPLICATION DESCRIPTION panel.

When you request a trial run, a batch job is submitted that produces a report of all specified pending updates without updating the database. An update run generates a batch job that updates the database and produces a report of all changed fields. Type t in the TYPE OF BATCH JOB field to specify a trial run, and press PF3 (End). The GENERATING JCL FOR A BATCH JOB panel, shown in EQQXSUBP - Generating JCL for a batch job, is displayed:

Figure 4. EQQXSUBP - Generating JCL for a batch job

EQQXSUBP -------------- GENERATING JCL FOR A BATCH JOB ------------------
Command ===>

Enter/change data below and press ENTER to submit/edit the JCL.

JCL to be generated for: MASS UPDATE OF APPLICATIONS

SYSOUT CLASS       ===> _           (Used only if output to system printer)
LOCAL PRINTER NAME ===> ________    (Used only if output on local printer)
                                    (Used only if CLASS is blank)
DATASET NAME       ===> XRAYNER.EIDA.ADMUP.LIST_____________________
                                    (Used only if CLASS and LOCAL PRINTER
                                    are both blank). If blank default name
                                    used is XRAYNER.EIDA.ADMUP.LIST

SUBMIT/EDIT JOB    ===> S           S to submit JOB, E to edit

Job statement    :
 ===> //XRAYNERE JOB  (890122,NOBO),'SIMON RAYNER',______________________
 ===> //       MSGCLASS=H,NOTIFY=XRAYNER,CLASS=A_________________________
 ===> //OUTPUT1  OUTPUT DEST=LAB21,DEFAULT=YES___________________________
 ===> //*________________________________________________________________

Check the report to see the applications that have been found with priority 5.
To update the AD database, rerun the job, this time with u in the TYPE OF BATCH JOB field.

Note: If you want to use mass update to change operation input arrival day or time, only those operations are changed where all operations in the application already have a value in both fields. You cannot leave these fields blank and then change them with mass update. Also, note that with mass update, no check is made to ensure that the deadline day and time is later than the operation input arrival day and time.