View previous topic :: View next topic
|
Author |
Message |
umed
New User
Joined: 13 May 2005 Posts: 38
|
|
|
|
Hi,
i am having n different files genrated thru n different jobs.Each file contains region code and record extracted for that region thru corresponding job.
like each file will contain only one record as given below :
reg1 999999
now i want to genrate a report such that i would get all the region counts in one file along with the total no of records ..like
Region records
--------------------------
reg1 1000
reg2 2000
---------------------------
Total Records 3000
can we genrate such report thru SORT utility?
If yes How?
Thanks in advance,
umed |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
In your example, if reg1 is the region, then what is 999999? Is that the total record count for that region (i.e the value that needs to be summed)?
Also, how do you intend to accomodate the fact that you have a variable number of input datasets? |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Concatenate all of the input files as SORTIN, and use OUTFIL with REMOVECC, HEADER1 and TRAILER1 to create the report. |
|
Back to top |
|
|
umed
New User
Joined: 13 May 2005 Posts: 38
|
|
|
|
Hi,
here n is fixed and the 99999 mentioned there is total no of records for that region
regards,
Umed |
|
Back to top |
|
|
|