Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 CICS web service from DB2 Triggers or... kiranprasad DB2 2 Wed Dec 20, 2017 11:10 am
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts JES2 job size field matching Windows ... SRICOBSAS All Other Mainframe Topics 4 Tue Sep 05, 2017 5:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us