Need to grab the changes from yesterday. An example would be great.
Don't you think that's a little vague? An example of what?
ICETOOL is NOT a plug-in for SUPERC. ICETOOL is NOT a compare product. You can do some matching functions with ICETOOL, but you're going to have to specify exactly what it is you want to do before anyone can help you.
Give an example of your input records (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of each relevant field.
Thanks for the candor! I will fill in more blanks next time.
We have account records from yesterday and account records from today that some or many of the fields have been changed during the day by the Customer Service Associates. We would like to output only the records that have been changed. Like a line compare report with Superc that flags the changed records with an identifier as described below. The files are FB and the Lrecl is 34.
Currently we are generating a report with Superc and these parameters:
SUPERC EXEC PGM=ISRSUPC,
then we scan the Superc report with SORT and output anything that is tagged as being changed, ie the deltas, with this command:
INCLUDE COND=(2,3,CH,EQ,C'I -')
We would like to do this in one fell swoop, 1 step. We have many that are like this and will replace with ICETOOL/ICEMAN if performance is improved.
That's what were doing ! Thanks again.
p.s. What is a plugin please. I actually don't know.
I - AAAAAAAAAAAAAAABBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCC
I - RRRRRRRRRRRRRRRDDDDDDDDDDDDDFFFFFFFFFFFFFFFFFFFF
Assuming you don't need the 'I -' (we could easily add it if it's needed) and that your input files have RECFM=FB and LRECL=80 (the job can be changed appropriately for other attributes), you could get the records that were changed using a DFSORT/ICETOOL job like the following:
I have no idea if this DFSORT/ICETOOL job would be faster than the SUPERC/SORT job you're using now. The best way to find out is to run them both with your own data and compare the performance based on your own criteria (e.g. CPU time, clock time, EXCPs, etc).