Topic
  • 9 replies
  • Latest Post - ‏2013-10-03T19:52:14Z by akhil.vasudevan
GeethaR
GeethaR
5 Posts

Pinned topic How to import Stored procedures from Mainframe DB2 into Data Studio

‏2013-08-30T01:01:14Z |

I am new to Mainframe/DB2. Just wondering there are no options available to refer directly from Data studio to Mainframe and just transfer/import stored procedures?

I am looking for functionality in Data Studio which would help import stored procedures (which I can not view it in Text Editor) from production DB2 Db on Mainframe. Since in Data Studio, I can see Databases/Tables/Schemas/Views/Stored Procedures etc in Development Environment. But Stored procedures are not viewable/editable in Text editor. Is there any access rights in mainframe prevents this or am I missing something available in Data Studio?

Please someone help me. Thank you

 

  • David.Zhu
    David.Zhu
    67 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-09-09T09:33:02Z  

    Hi, Geetha,

    You can create a database connection and a data development project according to following document. 

     

    After that, import the stored procedures from Mainframe DB2 according to following guide.

               Importing routines to a project

    Thanks.

  • GeethaR
    GeethaR
    5 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-09-10T00:02:07Z  
    • David.Zhu
    • ‏2013-09-09T09:33:02Z

    Hi, Geetha,

    You can create a database connection and a data development project according to following document. 

     

    After that, import the stored procedures from Mainframe DB2 according to following guide.

               Importing routines to a project

    Thanks.

    David.Zhu, Thank you for your reply. I really tried a lot.

    The problem is that, the stored procedures are listed by schema in Data Source Explorer. But When I try to open/open with editor nothing shows up.

    This happens for the stored procedures created as a package component (type as SPQ) in Mainframe (through ChangeMan). It seems it can be editable/viewable only in Mainframe, not from Data Studio. Not sure, since I am new to DB2/Mainframe. I do not see flexibility in using stored proc this way. I thought all (Import, Edit/view, Deploy) can be easily accessible from data studio itself as said in articles you mentioned above.

    May be any kind of decompile option to get those stored proc accessible from Data studio, just confused....

    I'd appreciate any help please. Thank you

    Updated on 2013-09-10T00:03:45Z at 2013-09-10T00:03:45Z by GeethaR
  • David.Zhu
    David.Zhu
    67 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-09-12T14:11:22Z  
    • GeethaR
    • ‏2013-09-10T00:02:07Z

    David.Zhu, Thank you for your reply. I really tried a lot.

    The problem is that, the stored procedures are listed by schema in Data Source Explorer. But When I try to open/open with editor nothing shows up.

    This happens for the stored procedures created as a package component (type as SPQ) in Mainframe (through ChangeMan). It seems it can be editable/viewable only in Mainframe, not from Data Studio. Not sure, since I am new to DB2/Mainframe. I do not see flexibility in using stored proc this way. I thought all (Import, Edit/view, Deploy) can be easily accessible from data studio itself as said in articles you mentioned above.

    May be any kind of decompile option to get those stored proc accessible from Data studio, just confused....

    I'd appreciate any help please. Thank you

    Hi, Geetha,

    Could you paste the source of the stored procedure which you can't open with routine editor? If can't provide whole source, you can just paste the head part and I can check what's the reason.

    Thanks.

  • GeethaR
    GeethaR
    5 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-09-13T13:22:14Z  
    • David.Zhu
    • ‏2013-09-12T14:11:22Z

    Hi, Geetha,

    Could you paste the source of the stored procedure which you can't open with routine editor? If can't provide whole source, you can just paste the head part and I can check what's the reason.

    Thanks.

    David, Thank you for your follow-up.

    As I said before it is through ChangeMan ZMF. So header is this format: CHGMAN.P.my app name.#my package.SPQ (my stored proc name).

    Not sure, any type of ChangeMan ZMF client tools will be helpful? Since it can not be viewable/editable in Data studio/Visual studio.

    Any suggestions would be appreciated. Thank you.

  • Equal
    Equal
    148 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-09-26T02:27:45Z  
    • GeethaR
    • ‏2013-09-13T13:22:14Z

    David, Thank you for your follow-up.

    As I said before it is through ChangeMan ZMF. So header is this format: CHGMAN.P.my app name.#my package.SPQ (my stored proc name).

    Not sure, any type of ChangeMan ZMF client tools will be helpful? Since it can not be viewable/editable in Data studio/Visual studio.

    Any suggestions would be appreciated. Thank you.

    Hi Geetha,

    We can't view external stored procedure if it's not created by Data Studio. But native SQL stored procedures can be viewed. Do you know which kind of stored procedure yours is? Thanks.

    Equal

  • GeethaR
    GeethaR
    5 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-09-30T15:35:47Z  
    • Equal
    • ‏2013-09-26T02:27:45Z

    Hi Geetha,

    We can't view external stored procedure if it's not created by Data Studio. But native SQL stored procedures can be viewed. Do you know which kind of stored procedure yours is? Thanks.

    Equal

    It is just Native SQL Stored procedure, created from ChangeMan ZMF (mainframe) package.

    I came to know that I can not edit SP outside ChangeMan ZMF package, just wondering why? Only ChangeMan ZMF client tools should be helpful, not Data Studio???

    I'd like to try whether I can create in DS and deploy it in MF (ChangeMan ZMF). Any suggestions would be helpful. Thank you.

     

  • akhil.vasudevan
    akhil.vasudevan
    5 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-10-02T17:41:56Z  
    • GeethaR
    • ‏2013-09-30T15:35:47Z

    It is just Native SQL Stored procedure, created from ChangeMan ZMF (mainframe) package.

    I came to know that I can not edit SP outside ChangeMan ZMF package, just wondering why? Only ChangeMan ZMF client tools should be helpful, not Data Studio???

    I'd like to try whether I can create in DS and deploy it in MF (ChangeMan ZMF). Any suggestions would be helpful. Thank you.

     

    Simple answer is NO. ChangeMan and Data Studio are two different software products and there is no bridge between these two unless you build something inhouse.

    Data Studio has its own deployment process and so does ChangeMan. I am guessing you are looking for an editor to create your procedure outside of ChangeMan ZMF. If that is YES, ChangeMan Eclipse Plugin is the best bet.

    Thanks

  • GeethaR
    GeethaR
    5 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-10-03T18:48:11Z  

    Simple answer is NO. ChangeMan and Data Studio are two different software products and there is no bridge between these two unless you build something inhouse.

    Data Studio has its own deployment process and so does ChangeMan. I am guessing you are looking for an editor to create your procedure outside of ChangeMan ZMF. If that is YES, ChangeMan Eclipse Plugin is the best bet.

    Thanks

    Akhil, Thank you very much for your response.

    I think ChangeMan ZMF Client Tools - ChangeMan ZMF Eclipse Plugin will be helpful.

    Like you said, yes I need to create a new stored procedure or existing stored procedure(Created from ChangeMan ZMF Mainframe package) which Data Studio does not allow to view/edit. IT seems Serena has those tools need to be purchased.

    If you have any suggestions, please let me know. I need to look Serena's website for further details.

     

    Thanks again.

     

  • akhil.vasudevan
    akhil.vasudevan
    5 Posts

    Re: How to import Stored procedures from Mainframe DB2 into Data Studio

    ‏2013-10-03T19:52:14Z  
    • GeethaR
    • ‏2013-10-03T18:48:11Z

    Akhil, Thank you very much for your response.

    I think ChangeMan ZMF Client Tools - ChangeMan ZMF Eclipse Plugin will be helpful.

    Like you said, yes I need to create a new stored procedure or existing stored procedure(Created from ChangeMan ZMF Mainframe package) which Data Studio does not allow to view/edit. IT seems Serena has those tools need to be purchased.

    If you have any suggestions, please let me know. I need to look Serena's website for further details.

     

    Thanks again.

     

    Remember ChangeMan ZMF Eclipse Plugin is not a free-of-charge product like Data Studio. I would recommend to discuss your needs with your z/OS sysprog team first. An useful document on ChangeMan Eclipse plugin is available below

    http://www.ibm.com/developerworks/rational/cafe/attachments/3420-2-3203/ChangeMan%20ZMF%20for%20Eclipse%20D041910.pdf

    Thanks