DB2 Stored Procedures

Ananya · New User Joined: 26 Feb 2004 Posts: 21 Location: Chennai

Dear All,

1. Can anybody explain me what a Stored Proc is ?

2. Also provide me with a Sample Functional code of how a Stored Proc would look like?

3. Also example (APPLICATIONS)of where the Stored Procs are used widely.

Thanks in advance

Cheers
Ananya.

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 257 Location: USA

Hello Ananya,

Check out the link below for more details on Stored Procedures.

Getting started with DB2 Stored procedures

Hope this helps,

Regards
Mayuresh Tendulkar

Ananya · New User Joined: 26 Feb 2004 Posts: 21 Location: Chennai

Dear All,

1. Can anyone tell me how to write a Stored Proc for DB2-SQL application?

2. I would be pleased if someone can give me a SAMPLE Stored PROC

3. Also provide me the link for converting VSAM to DB2 data using a Stored Proc.

Thanks in advance.

All Views are appreciated.

Cheers
--Ananya

Ravi · New User Joined: 23 May 2003 Posts: 4 Location: Chennai

1. Can anyone tell me how to write a Stored Proc for DB2-SQL application?
Ans: Using COBOL390 you can create a DB2 stored procedure. am now sure which version is used in PLI.

So if you have COBOL390 installed in your system you can write your own COBOL-DB2 stored procedures.

2. I would be pleased if someone can give me a SAMPLE Stored PROC
Ans: Its alreay being there in the post. If you want it anyway.. I can post that across...no probs..
3. Also provide me the link for converting VSAM to DB2 data using a Stored Proc.
Its just the same as writing a normal VS COBOL II program from copying VSAM to DB2 will a few standard formats to tell that this is a stored procedure.

Ananya · New User Joined: 26 Feb 2004 Posts: 21 Location: Chennai

Dear Ravi,

Thank u soooo much for the reply. As u promised, kindly send me across the sample Stroed Proc wrriten and called in a COBOL Application.

I will still put it clear for u....

1. Write a Stored Proc.

2. How to call in Cobol

3. Rules to be followed during the application development

Thanks in advance.

Cheers
--Ananya