pushpagiri
New User
Joined: 07 Jul 2005 Posts: 51
|
|
|
|
Hi,
Please try this problem..I want to count the duplicate records in file.
Code: |
Infile1:
aaaaa
aaaaa
bbbbb
bbbbb
bbbbb
bbbbb
ccccc |
Code: |
outfile:
aaaaa 2
aaaaa 2
bbbbb 4
bbbbb 4
bbbbb 4
bbbbb 4
ccccc 1 |
without using ICETOOL ,is it possible to complete this task? |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
without using ICETOOL ,is it possible to complete this task? |
Why "without ICETOOL"? If you have DFSORT, then you have ICETOOL. ICETOOL has been shipped free with DFSORT since 1991! |
|
Phantom
New User
Joined: 04 Sep 2005 Posts: 25
|
|
|
|
Pushpagiri,
Are you sure that you are having DFSORT ? If you are having DFSORT, then why don't you use ICETOOL as Frank Suggested ?
Without, using ICETOOL, I can think of this solution but the output file will have only one record for each key with the count that displays the number of times each key is repeated.
Check this:
Code: |
//R010 EXEC PGM=SORT
//SORTIN DD *
/*
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
INREC FIELDS=(1,5,9:X,SEQNUM,8,ZD)
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=(10,8,ZD)
/*
|
Hope this helps,
Cheers,
Phantom |
|