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

Report to be preapred using JCL


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gkarun

New User


Joined: 27 Apr 2005
Posts: 2
Location: Mumbai

PostPosted: Thu Sep 18, 2008 3:50 pm
Reply with quote

Hi
I need report which is like one which is prepared using QMF. I can use the QMFBATCH but this restricts the size of the report to 133. Is there any other method by which I can create a report and export to a dataset using a job ?

Arun
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Sep 18, 2008 8:43 pm
Reply with quote

Hello Arun and welcome to the forums,

Many (most) reports have a width limit of 133 because that is what is standard for many printers.

If you want something wider, simply create a file (rather than a report) as wide as you want. How will this "wide report" be used? Is it a file to download?

If you more clearly explain what you want and show some examples of your data and the output you want, we mey be able to offer better suggestions.
Back to top
View user's profile Send private message
gkarun

New User


Joined: 27 Apr 2005
Posts: 2
Location: Mumbai

PostPosted: Fri Sep 19, 2008 11:27 am
Reply with quote

Hi dick scherrer,

The file is of record length 950. We need to prepare a report and put in a pds on a weekly basis. This is not for printing any where. as the data is very huge we cant send it in excel format/.txt format.
I just want to get a report like one is prepared using QMF and exported to a dataset.Just need to automate this process.

Also we have a lot of other reports to be prepared regularly. So automation of this will help me a lot.I have a job to ftp the dataset to my system and preparation and sending these report comes very easy on automating this part

Thanks
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Sep 19, 2008 12:09 pm
Reply with quote

Hello,

You should be able to run your report creation in batch (which could be scheduled by the scheduling software/people) and create the new report as a member in a pds or other qsam file.
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts Ca7 long running jobs report All Other Mainframe Topics 1
No new posts Report of batch jobs JCL & VSAM 1
No new posts z/OS Modules Usage report using SMF 42 DFSORT/ICETOOL 2
Search our Forums:

Back to Top