Topic
  • 4 replies
  • Latest Post - ‏2014-12-14T06:11:53Z by James_Campbell_01
4YP5_Mustak_Ahammad_Majjagi
2 Posts

Pinned topic RDT - Need help with DB2 store proc set up and execution

‏2014-06-18T04:54:28Z |

Hi,

We have recently installed RDT in our shop. And want to try executing DB2 stored procedure (External).

Please walk thru the steps required for initial set up, Compile JCL and sample code.

Would like to call the DB2 stored proc from Java.

Updated on 2014-06-18T04:55:29Z at 2014-06-18T04:55:29Z by 4YP5_Mustak_Ahammad_Majjagi
  • RDzJohn
    RDzJohn
    270 Posts

    Re: RDT - Need help with DB2 store proc set up and execution

    ‏2014-06-18T12:56:20Z  

    We do not provide support for the z/OS software stack shipped with RD&T.  Suggest you append this question to one of the DB2 z/OS support forums.  You might get a quicker answer there.

    RDzJohn

  • 4YP5_Mustak_Ahammad_Majjagi
    2 Posts

    Re: RDT - Need help with DB2 store proc set up and execution

    ‏2014-06-19T09:16:09Z  
    • RDzJohn
    • ‏2014-06-18T12:56:20Z

    We do not provide support for the z/OS software stack shipped with RD&T.  Suggest you append this question to one of the DB2 z/OS support forums.  You might get a quicker answer there.

    RDzJohn

    Hi,

    Thanks for your prompt reply and suggestion.

    tried to search forum for DB2 z/OS but no success. Great help, if you can post this query there or share the link, will take myself.

    It's holding our work. Any help greatly appreciated!,

  • RDzJohn
    RDzJohn
    270 Posts

    Re: RDT - Need help with DB2 store proc set up and execution

    ‏2014-06-19T13:52:08Z  

    Hi,

    Thanks for your prompt reply and suggestion.

    tried to search forum for DB2 z/OS but no success. Great help, if you can post this query there or share the link, will take myself.

    It's holding our work. Any help greatly appreciated!,

    Only thing I can suggest is to use your mainframe support contract to open a pmr to ask a question.

     

    RDzJohn

  • James_Campbell_01
    James_Campbell_01
    1 Post

    Re: RDT - Need help with DB2 store proc set up and execution

    ‏2014-12-14T06:11:53Z  

    I know this reply is long after the discussion above, but for the record

    - The best general DB2 z/OS forum is at www.idug.org , and subscribe using the DB2-L & Forums pull down;
    - general introduction to DB2 Stored Procedures is at http://www.redbooks.ibm.com/abstracts/sg247604.html?Open  ( DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond )