View previous topic :: View next topic
|
Author |
Message |
kiran_polnati Warnings : 2 New User
Joined: 23 Jun 2005 Posts: 22
|
|
|
|
HI,
I have requirement that how to get the count (no of records) sorted .
sort fields = (1,3,CH,A)
SUM FIELDS = (5,4,ZD) - It will get the summing fields
i need no of records count also |
|
Back to top |
|
|
shankar.v
Active User
Joined: 25 Jun 2007 Posts: 196 Location: Bangalore
|
|
|
|
Code: |
// EXEC PGM=SORT
//SORTIN DD *
AAA 1
AAA 2
BBB 3
CCC 4
CCC 5
CCC 6
DDD 7
DDD 8
DDD 9
DDD 10
DDD 11
DDD 12
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=(4,2,ZD)
OUTFIL TRAILER1=('TOTAL NUMBER OF RECORDS ',COUNT),REMOVECC |
|
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
kiran_polnati wrote: |
i need no of records count also |
Do you want no. of records to be written in a new data set or in SYSOUT. If in SYSOUT, every DFSORT JOB will have messages of this type:
Code: |
ICE054I 0 RECORDS - IN: 5, OUT: 5
|
Hope this helps. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
I have requirement that how to get the count (no of records) sorted .
sort fields = (1,3,CH,A)
SUM FIELDS = (5,4,ZD) - It will get the summing fields
i need no of records count also |
Kiran,
Shankar's DFSORT job will give you a count of the output records, that is, the number of records remaining after SUM removes duplicate records. Is that what you want, or do you actually want a count of the number of records sorted before SUM removes duplicate records, or do you not really need the SUM statement at all?
If you need more specific help to get what you want, show an example of your input records and what you expect for output, and give the RECFM and LRECL of your input file. |
|
Back to top |
|
|
|