IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to handle historical data in a report with DFSORT?


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Lord.of.Wind

New User


Joined: 17 Nov 2005
Posts: 60

PostPosted: Tue Sep 15, 2009 3:39 pm
Reply with quote

Hi,

I have a report like the following:

Code:

-------------
Header
-------------
Month    count1          count2     count3     count4
Jan,09      666             555        444        333
Feb,09      111             222        333        444
Mar,09      777             888        999        111
...
Sep,09
----------------------
Notes:
count1 means ...
count2 means ...
count3 means ...
count4 means ...
-----------------------


All the count numbers are stored in GDG files. The GDG limit is 12.
Then the report should keep all historical count numbers, and its length is 133 digits.
How can I create this report with DFSORT? Always merge the report with last months? Could someone can help me?

Thanks a lot!
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Tue Sep 15, 2009 9:44 pm
Reply with quote

Lord.of.Wind,

You need to show us a sample of couple of input files and the desired output to be able to help you.
Back to top
View user's profile Send private message
Lord.of.Wind

New User


Joined: 17 Nov 2005
Posts: 60

PostPosted: Wed Sep 16, 2009 7:37 am
Reply with quote

Thank you Skolusu!
My input files are just containing count numbers, they PS files 20 digits long, such as
inputfile1: 410,148
inputfile2: 310,148
inputfile3: 210,148
inputfile4: 110,148

But NOW, I only need to generate only one month data in report. This is quite easy.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed Sep 16, 2009 9:23 am
Reply with quote

Quote:
they PS files 20 digits long
Do you mean 20 bytes LRECL?
then how come there are count3 and count4 in your first post you shown..

Also where is the month-year in input file?
Quote:
But NOW, I only need to generate only one month data in report.

Now you are confusing more...


Show us what output you are expecting for above input...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 1
No new posts Store the data for fixed length COBOL Programming 1
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
Search our Forums:

Back to Top