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
 

 

Report to be preapred using JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Report to be preapred using JCL
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

Site Director


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

PostPosted: Thu Sep 18, 2008 8:43 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Fri Sep 19, 2008 12:09 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am


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