I did search the Forums !
Need to grab the changes from yesterday.
Have to test the theory for proof and possibly an innovation document.
An example would be great.
Thanks in advance.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
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,
PARM=(DELTAL,LINECMP,
then we scan the Superc report with SORT and output anything that is tagged as being changed, ie the deltas, with this command:
SORT FIELDS=COPY
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).
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Or you could have told me that your input file has RECFM=FB and LRECL=34 and I could have shown you how to adapt the SELECT job I gave you to do the same thing in three passes instead of four passes.
Or you could change your job to use three passes instead of four passes by using an OUTFIL with INCLUDE and BUILD in CTL3CNTL for the SORT operator so you wouldn't need the fourth COPY operator.
But if you want to do it less efficiently, that's your choice.