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 (July, 2008)

 
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: Mon Jul 28, 2008 1:42 pm    Post subject: New DFSORT/ICETOOL Features (July, 2008) Reply with quote

PTF UK90013 for z/OS DFSORT V1R5 (July, 2008) provides important enhancements to DFSORT and DFSORT's ICETOOL for find and replace (FINDREP), group operations (WHEN=GROUP); sorting data between headers and trailers (DATASORT); keeping or removing the first n records, last n records and/or specific relative records (SUBSET); selecting the first n duplicate records (SELECT with FIRST(n) and FIRSTDUP(n)); splicing with non-blank fields (SPLICE with WITHANY); displaying and writing counts (DISPLAY with COUNT, EDCOUNT, BCOUNT and EDBCOUNT, and COUNT with ADD, SUB, WRITE, TEXT, DIGITS, EDCOUNT and WIDTH); reports with multiple and multipart titles (DISPLAY and OCCUR with TITLE, TLEFT and TFIRST); reports without carriage control characters (DISPLAY and OCCUR with NOCC); additional defaults (BLKSIZE for DUMMY, SKIP=0L for SECTIONS, and SORTOUT=ddname for FNAMES); easier migration from other sort products, and more.

For complete details on these new features, see my "User Guide for DFSORT PTF UK90013" paper (sortugpf.pdf) at:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000085
_________________
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


Last edited by Frank Yaeger on Mon Oct 25, 2010 11:55 am; edited 2 times in total
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Alain Benveniste
Beginner


Joined: 04 May 2003
Posts: 92
Topics: 4
Location: Paris, France

PostPosted: Tue Jul 29, 2008 3:44 pm    Post subject: Reply with quote

Frank,

I have just read the new features and I find them very close to what has been so often asked through the forums.
Since a way to do it was available, I would never bet a cent to see WHEN=GROUP inserted in the interns of dfsort !
Well, I
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: Tue Jul 29, 2008 4:02 pm    Post subject: Reply with quote

Quote:
I have just read the new features and I find them very close to what has been so often asked through the forums.


No coincidence there. While participating in the Forums, I monitor what people are trying to do and use that as input to the planning process for new DFSORT/ICETOOL functions.

Quote:
Since a way to do it was available, I would never bet a cent to see WHEN=GROUP inserted in the interns of dfsort !


The IFTHEN group trick you so kindly provided several years ago has been extremely useful. But it's tricky and has limitations. So I "invented" WHEN=GROUP as an easier, more flexible way to do group operations with DFSORT. Your original "trick" was the inspiration for this new function and we all owe you thanks for that. 8)

Quote:
Well, I
_________________
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
mickeygoo
Beginner


Joined: 15 Nov 2007
Posts: 26
Topics: 7

PostPosted: Fri Mar 26, 2010 3:14 pm    Post subject: Reply with quote

IFTHEN=WHEN=GROUP... rocks!!!

8)
Back to top
View user's profile Send private message
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