Change database in between RMOGRW programs.

[Nithiya Nedunchezhian]

​Hi,

How to change database name in between RMOGRW statement to Select reports etc...apart from CONTROL statement ?

Thanks,
Nithiya N

[John Misinkavitch]

Hello Nithiya,
This may be better as a Support case. I would like to see the JCL you are using and understand better what you are trying to accomplish.
Are you asking if you can have an RMOGRW job that selects data from more than 1 database at a time?
john

------------------------------
John Misinkavitch
CA Support
------------------------------

[Lenn Thompson]

@John Misinkavitch @Nithiya Nedunchezhian -- any update on this that you can share with other community members? ​​​

------------------------------
Lenn Thompson
Community Manager, Mainframe Division
Broadcom Inc.
[e-mail]
------------------------------

[John Misinkavitch]

Hello Nithiya,
If you are using a one step job with RMOGRW, you cannot access multiple databases.
If the goal is to gather information from multiple databases and finish with 1 dataset or sysout with all the information in it, I would suggest  something like a multiple step job and use the JCL to MOD the output into one sysout/dataset. Or you could have multiple jobs that write the output to datasets and then use some other utility or program to put them all together.
Then you could print it or use other utilities against it.
As we have not seen the JCL or been able to discuss exactly what you are looking, hopefully this answers your question.

------------------------------
John Misinkavitch
CA Support
------------------------------