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 do you generate daily,weekly,monthly reports using GDG

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
kndeepthi

New User


Joined: 20 Jan 2006
Posts: 4

PostPosted: Wed Jan 25, 2006 3:50 pm    Post subject: How do you generate daily,weekly,monthly reports using GDG
Reply with quote

hello,

i wanted to know how do you generate daily,weekly,monthly reports using gdg in real environment?

want to know how to create current generations?

want coding for daily,weekly,monthly reports?
Back to top
View user's profile Send private message

Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Wed Jan 25, 2006 4:20 pm    Post subject: Re: its urgent
Reply with quote

HI kndeepthi,


Quote:
want to know how to create current generations?


Create one GDG base and code (+1) which will create current generation of GDG


Quote:
i wanted to know how do u generate daily,weekly,monthly reports using gdg in real environment?

Schedule 3 jobs of which
1 runs daily which creat daily generation and report
2nd job runs weekly which copy all the data from daily GDG(6 GDGs) and creat one GDG. This contains data for weekly. and delete all the daily generation
3rd job runs on monthly, which copy weekly data into Monthly file and delete all weekly generation.

Hope this clear now....

Regards
Rupesh
Back to top
View user's profile Send private message
kndeepthi

New User


Joined: 20 Jan 2006
Posts: 4

PostPosted: Thu Jan 26, 2006 8:16 pm    Post subject: Re: How do you generate daily,weekly,monthly reports using G
Reply with quote

1 runs daily which creat daily generation and report
2nd job runs weekly which copy all the data from daily GDG(6 GDGs) and creat one GDG. This contains data for weekly. and delete all the daily generation
3rd job runs on monthly, which copy weekly data into Monthly file and delete all weekly generation.


how to do this?
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Sat Jan 28, 2006 11:18 pm    Post subject:
Reply with quote

Create a GDG w/6 entries for daily.
Create a GDG w/4 entries for wkly.
Create a GDG w/12 entries for moly.

When the wkly runs include a step (IEFBR14) to delete all the daily gens, e.g. dsn=p.dly.data,disp=(old,delete). Do similar w/wkly gens.

The problem w/wkly, moly is that the # of wks in a mo vary. If you can convince TPTB to go to 4 wks instead of moly, you've got something workable.
Back to top
View user's profile Send private message
sarojini

New User


Joined: 08 Dec 2005
Posts: 10
Location: India

PostPosted: Sun Jan 29, 2006 9:57 am    Post subject: question on gdg
Reply with quote

how to copy 6 daily gdgs into a single gdg
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Sun Jan 29, 2006 11:10 pm    Post subject:
Reply with quote

If you have GDG entries like A.B.C.G000nV00, use DSN=A.B.C to read ALL the generations of A.B.C
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Mon Jan 30, 2006 8:44 am    Post subject: Re: How do you generate daily,weekly,monthly reports using G
Reply with quote

Hi kndeepthi,

Here a solution that may work for you.

1 - Create 3 GDGs with a depth of 2. One for Daily, Weekly, and Monthly reports.

2 - Create an empty GDG for each.

3 - Daily job runs creating (+1) Daily GDG.

4 ? On the daily reporting run.
a. Use the most currently daily GDG (0) for the daily reports.
b. Copy the Daily GDG (0), appending it to the weekly GDG (0) creating weekly GDG (+1).
c. Copy the Daily GDG (0), appending it to the monthly GDG (0) creating weekly GDG (+1).

5 ? On the Weekly reporting run.
a. Use the most current weekly GDG (0) for the weekly reports. This assumes that the daily reports, and copies, have completed before the weekly reports start.
b. Delete all weekly GDGs
c. Create empty weekly GDG

6 ? On the Monthly reporting Run.
a. Use the most current Monthly GDG (0) for the monthly reports. This assumes that the daily reports, and copies, have completed before the monthly reports start.
b. Delete all monthly GDGs
c. Create empty monthly GDG

You can use several IBM utilities to copy the gens.

Happy reporting, icon_smile.gif

Dave
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
No new posts Daily report to be extracted from CA ... polymathtarun DFSORT/ICETOOL 5 Mon Jul 11, 2016 4:33 pm
No new posts Generate Cohort report using SORT Indrajit_57 SYNCSORT 6 Wed Jun 01, 2016 9:41 am


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