Posted: Tue Oct 06, 2009 2:02 am Post subject: Record Count Based on a field value
I have a requirement to get the record count from a dataset based on a value of a field in each record.
The dataset i am using is a position based file where in position 3 to 7 is Test Id. I have to get the record count of each test id for e.g if Test id 7 has 5 records i have to generate a output file with the details of the Test Id Number and the record count for this Test id.
So i have to read my dataset from the position 3 to 7 and find out the value of it and then get the counts of the records/number of occurences of this value in the dataset and create a output dataset.
I am new to mainframe can anyone help me out in this? your response to this ASAP is highly appreciated.
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:
Joined: 18 Feb 2006 Posts: 812 Location: San Jose, CA
Posted: Tue Oct 06, 2009 3:54 am Post subject:
If you had DFSORT, then you'd have DFSORT's ICETOOL.
If you have Syncsort, then I can't help you. I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort. _________________ Frank Yaeger - DFSORT Development Team (IBM) - firstname.lastname@example.org
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
Joined: 09 Aug 2008 Posts: 1631 Location: Mumbai, India
Posted: Tue Oct 06, 2009 7:18 pm Post subject:
Can we do the same thing using syncsort or a plain JCL
What is "plain JCL" -- JCL itself does nothing. You need to execute some program(s)..whether user written or provided by vendors. Are you sure you're using SyncSort? How do you conclude that? _________________ Regards,
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