SP execution

IBM's flagship relational database management system

SP execution

Postby Prajakta_T » Mon Oct 31, 2011 5:01 pm

Hi all,

1)How can I execute my stored procedure in mainframe environment. I am handling SP-DB2 for the first time, previously I was working on CICS. I wrote A SP-cobol and database is ready with me. Now I have to check whether my SP is correct or not? how I can check this code? I need the steps-commands to execute this SP and where I can check the list of errors? Please give me information in brief.
2)Which things I have to keep in mind while handling stored procedures?
Posts: 1
Joined: Mon Oct 31, 2011 4:23 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SP execution

Postby cet2002 » Thu Nov 03, 2011 10:59 pm

Hi Prajakta,

1)You will need a DDL which has details corresponding to the input-output parameters passed in to/taken out from the SP.
2)Once the DDL is created,you will need to "grant access to public" for the DDL .. else the SP will give access authorisation error at a later stage.
3)Compile the SP.
4)Make sure that the SP is started in the address space where it is supposed to run.
5)SImilar to a normal Cobol program , you can't see the displays in spool in this case.The displays would be present in the address space

All the best with your coding/testing
Posts: 2
Joined: Thu Nov 03, 2011 10:44 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DB2


  • Related topics
    Last post