print stat for the fields using ICEMAN



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

print stat for the fields using ICEMAN

Postby Danielle » Wed Oct 21, 2009 8:55 am

Hi all
Please help,
I would like to print a statistic for the fields using ICEMAN
say prefer astatistic of 2 fields A and B
A start at pos 83,10,ch
B start at pos 1,9,ch

so for each type in field A, count number of rows in filed B for each type in field A
for ex:

input file :
A B
aaaa 123458798
aaaa 125623469
aaaa 368859008
abcd 769843578
abcd 688767897
...

output file the statistic like:

aaaa 3
abcd 2
...

Thanks a lot
Danielle
Danielle
 
Posts: 8
Joined: Fri Aug 14, 2009 8:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: print stat for the fields using ICEMAN

Postby Frank Yaeger » Wed Oct 21, 2009 9:38 pm

Here's a DFSORT/ICETOOL job that will do what you asked for:

//S1   EXEC  PGM=ICETOOL
//TOOLMSG   DD  SYSOUT=*
//DFSMSG    DD  SYSOUT=*
//IN DD DSN=... input file
//OUT DD SYSOUT=*
//TOOLIN DD *
OCCUR FROM(IN) LIST(OUT) ON(83,10,CH) ON(VALCNT,U05) BLANK -
  NOHEADER NOCC
/*


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:

http://www.ibm.com/support/docview.wss? ... g3T7000080
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 JCL

 


  • Related topics
    Replies
    Views
    Last post