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
 

 

Is the Stored Procedure effects the size of the database

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

New User


Joined: 12 Jun 2005
Posts: 7
Location: hyderabad

PostPosted: Thu Jun 23, 2005 7:31 pm    Post subject: Is the Stored Procedure effects the size of the database
Reply with quote

1. hi can any one tell me
is the stored procedure effects the size of the database.
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Thu Jun 23, 2005 7:34 pm    Post subject: Re: size of database
Reply with quote

I think Yes.

Regards,

Priyesh.
Back to top
View user's profile Send private message
brganeshbabu

New User


Joined: 23 Jun 2005
Posts: 34
Location: Chennai

PostPosted: Tue Jun 28, 2005 2:56 pm    Post subject:
Reply with quote

Certainly a stored procedure affects the size of the database
Back to top
View user's profile Send private message
paru

New User


Joined: 24 Jun 2005
Posts: 9
Location: INDIA

PostPosted: Wed Aug 17, 2005 11:45 am    Post subject:
Reply with quote

Using Stored Procedure will reduce the size of the database.

Regards,

Paru icon_smile.gif
Back to top
View user's profile Send private message
Karthikt

New User


Joined: 15 Aug 2005
Posts: 51

PostPosted: Thu Aug 18, 2005 6:00 pm    Post subject:
Reply with quote

To my knowledge, I feel that stored procedures simplifies the SQL queries and maintains integrity and security. Can you explain me more, how it has impact on the size of the database?

If several programs want to execute a set of SQL queries, then they will call a stored procedure which has functionalites of such SQL queries by approriate CALL statement. This prevents the one from knowing DB2 relaed information and adds security to the system.
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 To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
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 IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am


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