SQL stored procedure

sabarishas2k · New User Joined: 09 Jan 2009 Posts: 3 Location: Kerala

I have a SQL stored procedure(it is written with create procedure statement with BEGIN and END statements) which needs to be executed in mainframe .. Any one please tell me what are all the steps that i need to follow before executing this stored procedure in mainframe.

GuyC · Posted: Tue Mar 01, 2011 5:13 pm

one of the first steps is to install DB2

sushanth bobby · Posted: Tue Mar 01, 2011 5:26 pm

Hi Sabarishas,

First you need to know the sub-system where is it needs to be created and you will be needing access to it.

You can get help from your collegues/DBA's in your shop, who have already done this.

Google this excellent redbook from IBM, which will give you all the details regarding the stored procedures "DB2 for zOS Stored Procedures Through the CALL and Beyond"

Thanks,
Sushanth

Anuj Dhawan · Posted: Tue Mar 01, 2011 7:25 pm

sushanth bobby · Posted: Tue Mar 01, 2011 8:33 pm

Anuj,

Akatsukami · Posted: Tue Mar 01, 2011 9:11 pm

GuyC · Posted: Tue Mar 01, 2011 10:25 pm

Thank you, Thank you, I'm here all week

At first I was really pondering on where to begin the explanation, but all steps without any background on the environment: "install DB2" was all I could come up with.

Anuj Dhawan · Posted: Wed Mar 02, 2011 2:24 pm

In fact, I begin with something like "This is beyond the scope of a Forum to explain...", compiled a long reply and when I preview...whoof -- your one liner seemed too mighty to post my reply..!

enrico-sorichetti · Posted: Wed Mar 02, 2011 2:25 pm