Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to handle historical data in a report with DFSORT?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: How to handle historical data in a report with DFSORT?
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    Post subject:
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us