View previous topic :: View next topic
|
Author |
Message |
rahul_kk
New User
Joined: 24 Nov 2006 Posts: 5 Location: Chennai
|
|
|
|
I need to modify all the headings in the reports generating from QMF PROCs. This heading will be available in a DB2 table. There will be many QMF reports in many batch jobs. How can I accomplish this? Please help
If I set a global variable and store the value from DB2 table, will this be available thorough out the batch job cycle?
Thanks in advance
Rahul |
|
Back to top |
|
|
chandracdac
New User
Joined: 15 Jun 2007 Posts: 92 Location: bangalore
|
|
|
|
1. Prepare the header file separately.
2. Run you query thry JCL so that you will get the data in output file
3. Merge both files so that you will get the exact thing what you are expecting.
Thanks |
|
Back to top |
|
|
rahul_kk
New User
Joined: 24 Nov 2006 Posts: 5 Location: Chennai
|
|
|
|
Thanks for your reply. We have program name, header name, date and time in the first line. So, I have done this in another way. Created a stored procedure (a cobol program gets this heading and send it as OUT parameter to stored procedure).
1. Set global(heading_name='')
2. Call Stored_Procedure(&heading_name)
3. Mention this '&heading_name' in QMF Form (FORM.PAGE)
First 2 steps needs to be incorporated in all QMF PROCs before executing any SQL.
I tried this and is working fine.
Rahul KK |
|
Back to top |
|
|
|