MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2014

CLP or CL - script for hypers



fixed

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/






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact