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:
  1. 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
  2. Enter the CLEAR command on the command line to delete pending updates that you no longer need.
  3. 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
  4. 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 **************************
  5. 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.
  6. 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.
  7. 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:

  8. The target field is 8 bytes long.
  9. Three instances of the target field contain PAYUPD, PAYUPDAT, and UPDATE.
  10. Old data is UPD.
  11. New data is BKUP.

    After the mass update:

  12. The updated fields contain PAYBKUP, PAYBKUPA, and BKUPATE respectively.
  13. Press PF3 (End). You return to the MASS UPDATING OF APPLICATION DESCRIPTION panel.
  14. 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___________________________
     ===> //*________________________________________________________________
  15. Check the report to see the applications that have been found with priority 5.
  16. 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.