Page 1 of 1

Replace ICETOOL logic with DFSORT

PostPosted: Sat May 01, 2010 5:19 pm
by nathan.ds
In our shop, the management wanted to convert all the ICETOOL logic to a Normal SORT (PGM=SORT) logic or any equivalent generic SORT. The requirement is as follows,

We have 2 files, Current file is called File-A and Previous file is File-B. Now we wanted to compare File A&B and prepare 3 different files (New records, Deleted Records and Changed records). The Record length is 900 and both the file layout are same.

1. Compare File A & File B – If any new records are added in File-A then write into File-3
2. Compare File A & File B – If any records are deleted in File-A then write into File-4
3. Compare File A & File B – If any new records are Modified or Changed in File-A & B then write into File-5.

I have written a SORTXSUM logic, it track all the add & modified records but couldn’t get the desired solution. If the SORT can replace with multiple steps are fine. But need equivalent replacement. Appreciate your advise.

Thanks,
Nathan.

Re: Replace ICETOOL logic with DFSORT

PostPosted: Sun May 02, 2010 12:09 am
by dick scherrer
Hello and welcome to the forum,

It will help if you post the ICEOOL statements you want to replace. . .

Your management needs to be aware that ICETOOL was created to provide additional capability - not to merely provide a different way to do the same things SORT already did. . .

If you mangement does not want to use what they have a license for, you may need to actually replace the ICETOOL step with a real program. . .

If the SORT can replace with multiple steps are fine.
In well managed organizastions, this is NOT fine. . .

Re: Replace ICETOOL logic with DFSORT

PostPosted: Mon May 03, 2010 10:16 pm
by Frank Yaeger
Please don't post the same question on multiple boards. I'm locking this thread.