Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Stored Procedures

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Ananya

New User


Joined: 26 Feb 2004
Posts: 19
Location: Chennai

PostPosted: Thu Feb 26, 2004 5:10 pm    Post subject: DB2 Stored Procedures
Reply with quote

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.
Back to top
View user's profile Send private message

mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Thu Feb 26, 2004 5:30 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Ananya

New User


Joined: 26 Feb 2004
Posts: 19
Location: Chennai

PostPosted: Wed Mar 17, 2004 2:51 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Ravi

New User


Joined: 23 May 2003
Posts: 3
Location: Chennai

PostPosted: Wed Mar 17, 2004 3:12 pm    Post subject: DB2 Stored Procedures
Reply with quote

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.
Back to top
View user's profile Send private message
Ananya

New User


Joined: 26 Feb 2004
Posts: 19
Location: Chennai

PostPosted: Wed Mar 17, 2004 5:06 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Is possible to call subprogram from c... cmsmoon COBOL Programming 3 Fri Aug 05, 2016 6:46 pm
This topic is locked: you cannot edit posts or make replies. Stored procedure on Federated thru DB2 arif677 DB2 6 Tue May 31, 2016 11:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us