MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

New DFSORT/ICETOOL Features (Dec, 2004)

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Fri Dec 17, 2004 10:42 am    Post subject: New DFSORT/ICETOOL Features (Dec, 2004) Reply with quote

PTF UQ95214 for z/OS DFSORT V1R5 and PTF UQ95213 for DFSORT R14 (available now), provide important enhancements to DFSORT and DFSORT's ICETOOL for conditionally reformatting records (IFTHEN); overlaying only selected parts of records (OVERLAY); larger numeric fields and constants; new data formats for extracting digits (SFF, UFF), and displaying TOD and ETOD date and time values (DCn, TCn, DEn, TEn); restarting sequence numbers (RESTART); join and match operations; date and time constants; conversion of statistical and count values; reports; easier migration from other sort products, and more.

For complete details on these new features, see my "User Guide for DFSORT PTFs UQ95214 and UQ95213 (sortpdug)" paper at:

www.ibm.com/servers/storage/support/software/sort/mvs/pdug/index.html
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Fri Dec 17, 2004 10:54 am    Post subject: Reply with quote

Congrats Frank !!. On a first glance , BUILD ,OVERLAY & IFTHEN sounds interesting. Keepbase with splice also might be useful !!

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Fri Dec 17, 2004 11:32 am    Post subject: Reply with quote

Thanks, Kolusu. A lot of the new functions are solutions for questions from this board. I've been playing with IFTHEN and OVERLAY for several months now and it's pretty amazing what you can do with them. I also think the SFF and UFF formats, RESTART for sequence numbers, COUNT+n and COUNT-n, larger numeric fields, KEEPBASE, multiline headings for DISPLAY and OCCUR and some other items will make DFSORT/ICETOOL users happy (and users of that other product jealous).
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Fri Dec 17, 2004 11:45 pm    Post subject: Reply with quote

Frank,

Code:

and users of that other product jealous


Yep, you are absolutely right. I'm desperate to work on DFSORT but.............

Gr8 Job, keep it up.

Thanks,
Phantom
Back to top
View user's profile Send private message
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Sat Dec 18, 2004 10:52 am    Post subject: Reply with quote

Phantom,

In case your management might consider switching:

******
If anyone would like some documents prepared by the DFSORT Team that discuss what we see as the advantages of DFSORT over Syncsort as well as migration considerations, send me an e-mail (yaeger@us.ibm.com). Please put "DFSORT" somewhere in your Subject line to catch my attention. (These are updated versions of the documents, so if you previously received the documents, you might want to request the new ones.)
******
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Fri Dec 24, 2004 9:52 am    Post subject: Reply with quote

Hi Frank,

I'm not sure whether this is already available in DFSORT or its in ur TO DO list.

Can you update DFSORT to support more BIT operations like XOR, OR etc...Sometime back I was writing a small code in sort to compare two datasets. The same old logic of inserting a literal '1' in all records of file 1 and '2' in the records of file 2 and summing on the literal.

After comparison, the XOR operators will be useful in comparing the MATCHING INSERTS & DELETES and highlight the point of difference. If the two bits are same, then XOR will result in X'00' else it will display some junk value which can be used to highlight the exact point of difference.

Any thoughts ?

Thanks,
Phantom
Back to top
View user's profile Send private message
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Fri Dec 24, 2004 11:03 am    Post subject: Reply with quote

Phantom,

Bit operations are already on the list of candidates for future enhancements to DFSORT, but it's a long list, and all of the items have to be prioritized against each other. Suggestions are always welcome, but I can't discuss specifics or make any promises.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Fri Dec 24, 2004 11:09 am    Post subject: Reply with quote

Thanks Frank,

Gr8 work. Keep it up.

Phantom
Back to top
View user's profile Send private message
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Fri Feb 25, 2005 8:07 pm    Post subject: Reply with quote

The Dec, 2004 DFSORT PTF functions have now been integrated into the z/OS DFSORT V1R6 books. You can use these books for z/OS DFSORT V1R5 and above. You can also use these books for DFSORT R14 if you ignore the material on Memory Object Sorting, NULLOUT and NULLOFL which are only available with z/OS DFSORT V1R5 and above.

You can access all of the DFSORT books from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group