Replace ICETOOL logic with DFSORT



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Replace ICETOOL logic with DFSORT

Postby nathan.ds » Sat May 01, 2010 5:19 pm

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.
nathan.ds
 
Posts: 1
Joined: Sat May 01, 2010 4:35 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Replace ICETOOL logic with DFSORT

Postby dick scherrer » Sun May 02, 2010 12:09 am

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. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Replace ICETOOL logic with DFSORT

Postby Frank Yaeger » Mon May 03, 2010 10:16 pm

Please don't post the same question on multiple boards. I'm locking this thread.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post