|
View previous topic :: View next topic
|
| Author |
Message |
gargi koley
New User
Joined: 11 Jan 2008
Posts: 10
Location: satyam gateway,hi-tech citi,hyderabad
|
|
|
|
hi all,
i need to get a sort card for a input file which has been already sorted based on account number (acen).
The input file looks like:
Acct No. Timestamp
1 T1
2 T2
3 T1
4 T3
5 T1
6 T2
The output file should look like :
Timestamp Count
T1 3
T2 2
T3 1
The comparision for the Timestamp is required only for date filed(1:10)[/u] |
|
| Back to top |
|
 |
murmohk1
Senior Member
.jpg)
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
| Back to top |
|
|
gargi koley
New User
Joined: 11 Jan 2008
Posts: 10
Location: satyam gateway,hi-tech citi,hyderabad
|
|
|
|
hi murali
i am not able to open the link
can u get me the right link
thanks & regards
gargi |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
You can use a DFSORT like the following to do what you asked for:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
1 T1
2 T2
3 T1
4 T3
5 T1
6 T2
/*
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(40,2,CH,A)
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(40,2,
TRAILER3=(5:40,2,32:COUNT=(EDIT=(IIIIT))))
/*
|
|
|
| Back to top |
|
|
|
|
