MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Stored procedures

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
bakul
Beginner


Joined: 20 Sep 2004
Posts: 7
Topics: 4
PostPosted: Sun Oct 03, 2004 11:31 pm    Post subject: Stored procedures Reply with quote
Where can I get a list of all the disadvantages or drawbacks of stored procedures?
What are the major disadvantages/drawbacks of using stored procedures in a mainframe environmenet?
Question
Back to top
View user's profile Send private message Send e-mail
SureshKumar
Intermediate


Joined: 23 Jan 2003
Posts: 211
Topics: 21
PostPosted: Mon Oct 04, 2004 2:45 pm    Post subject: Reply with quote
Bakul,
You have asked a very generic question. You would have to browse thru the manuals to understand the various options available. Stored Procedure is like a 'tool', not all tools can be used all the time. It depends on the requirement. It's not only what SP's can do, there is also a lot about the interfaces - like DB2 Connect. Its certainly not recommended for use within MVS like a batch process. It is designed for a middle tier application to access the data on a minframe - DB2 (though other medium can be accessed, its not recommended). Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group