CA View/Deliver

Expand all | Collapse all

Change database in between RMOGRW programs.

  • 1.  Change database in between RMOGRW programs.

    Posted 08-08-2019 11:45 AM
    ​Hi,

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

    Thanks,
    Nithiya N


  • 2.  RE: Change database in between RMOGRW programs.

    Posted 08-08-2019 12:48 PM
    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
    ------------------------------



  • 3.  RE: Change database in between RMOGRW programs.

    Posted 08-14-2019 01:31 PM
    @John Misinkavitch @Nithiya Nedunchezhian -- any update on this that you can share with other community members? ​​​

    ------------------------------
    Lenn Thompson
    Community Manager, Mainframe Division
    Broadcom Inc.
    lenn.thompson@broadcom.com
    ------------------------------



  • 4.  RE: Change database in between RMOGRW programs.

    Posted 08-14-2019 04:29 PM
    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
    ------------------------------