View previous topic :: View next topic
|
Author |
Message |
kndeepthi
New User
Joined: 20 Jan 2006 Posts: 4
|
|
|
|
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 |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
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 |
|
|
kndeepthi
New User
Joined: 20 Jan 2006 Posts: 4
|
|
|
|
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 |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
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 |
|
|
sarojini
New User
Joined: 08 Dec 2005 Posts: 10 Location: India
|
|
|
|
how to copy 6 daily gdgs into a single gdg |
|
Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
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 |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
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,
Dave |
|
Back to top |
|
|
|