I need to apply a large amount of hypers to a 3rd party application.
The fixes are sent to us via word doc.
These will applied on test system, multiple times.
We delete/restore the entire test system, (when data gets old), reapply the upgrades, then apply the hypers.
Normally, this list is small, and I copy/paste, run the commands one at a time.
However, this set of fixes is quite large, below is a small sample of the fixes.
The IC8270PGMS library name in the example below will need to change.
I was thinking of either a CLP, or maybe a CL , (no need to compile), or AJS job, or possibly some other method.
Pros/Cons of different methods,
1) need to see a good job log,
2) probably should stop if an error occurs, take corrective action.
3) Possible restart capabilities
Any thoughts from the group.
d. Install Interface Type Parm Dsc, Interface Type Parm A and Interface Type Parm V chnages
i. RUNSQL REQUEST('DELETE FROM IC8270PGMS/CBF4REP where F4IFTY = ''GENPRV'' AND F4SSFB = ''V'' AND F4NRD1= 42')
ii. QSYS/CPYF FROMFILE(IC8270B02S/CBF4REP) TOFILE(IC8270PGMS/CBF4REP) MBROPT(*ADD) FMTOPT(*MAP *DROP)
iii. QSYS/CPYF FROMFILE(IC8270B02S/CMQHREP) TOFILE(IC8270PGMS/CMQHREP) MBROPT(*ADD) FMTOPT(*MAP *DROP)
iv. RUNSQL REQUEST('DELETE FROM IC8270PGMS/CMQIREP where QIIFTY = ''GENPRV'' AND QINRD1 = 42')
v. QSYS/CPYF FROMFILE(IC8270B02S/CMQIREP) TOFILE(IC8270PGMS/CMQIREP) MBROPT(*ADD) FMTOPT(*MAP *DROP)
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx
http://www.pencor.com/
As an Amazon Associate we earn from qualifying purchases.