View previous topic :: View next topic
|
Author |
Message |
Dinesh Manivannan
New User
Joined: 17 Mar 2008 Posts: 17 Location: India
|
|
|
|
Hi all,
I have a requirement to generate 2 reports. We can use two methods to generate the report file.
1) Using 3 Cursors in a COBOL program. One cursor will be used to generate one report file. Other two cursors will be used to generate another report file.
2) Use two unload steps executing DSNUTILB. One report will be generated from one query directly. Other 2 queries will be joined to create another unload query.
When both are executed, they are taking less time since the development environment does not have much data.
Questions:
a) Which method is the best to use? I assume that utility will be more effective than the program.
b) Any way to determine which is the best solution?
Note: Tables used in the queries are used day long by some of the online programs.
Need the legends help on this!
Thanks
Dinesh M |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Quote: |
Which method is the best to use? I assume that utility will be more effective than the program. |
-- Yes
Quote: |
b) Any way to determine which is the best solution? |
-- load the actual data and test in dev env and see the stats or talk to the performance group or DBA.
However, if you can do a unload of these tables and use a SORT on them to make your reports then that would be efficient as you don't want your online disturbed by more accesing these tables in batch. |
|
Back to top |
|
|
Dinesh Manivannan
New User
Joined: 17 Mar 2008 Posts: 17 Location: India
|
|
|
|
Thanks a lot. |
|
Back to top |
|
|
|