I have a requirement where we need to merge available GDGs and create a report on a tabular form. Now I went thru numerous examples which helps you merging two files with SPLICE on ICETOOL. But in my requiement the number of files varies from one to 30 in a particulat month. I mean in the day-1 its just one file. in Day 5 there would be 5 files to merge. So basically my files are catalogued as an GDG version to a base. Let me give an example to explain more.
So this way I see a new version gets catalogued. Now I need a final process which summarizes them on a daily basis by reading all the available version. So Looking at the 1st two versions it should have below result.
So everyday with an additional GDG version I should see one more extra column gettting added. The number of rows on every GDG is fixed. In this case its 3. The number of coumn is also fixed. Onlt the value on the 2nd column varies and the 1st column is a key and remain fixed on every GDG version.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Do you have any solution in mind ??
If the records can be changed to include the "day", you won't need to work around how many generations to use. You can read the entire gdg base and control printing and summing by the day in the reocrds.
the process would run everyday for sure on a fixed time.
The process can be scheduled to run every day at the same time, but there almost certainly will be an occasion when the job is not run on some day. These things do happen and are usually more likely when there has been no plan made to handle them.
If you use the gdg base as input, the problem pretty much goes away.
May be you didnt understand the need. My need was to merge the available GDGs to a single file based on a key field. Is there a way to do it. I know we can do it by ICETOOL for two files but then I dont know how do we do it when we have multile versions on a GDG.