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
 

 

Need Help about stored procedures

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

New User


Joined: 22 Sep 2005
Posts: 32

PostPosted: Wed Nov 29, 2006 7:17 pm    Post subject: Need Help about stored procedures
Reply with quote

Hi,

In a client we must begin to program many stored procedures of DB2. The following doubts arise to me that I raise you to see if you can help me:

1. From a point of view of the programming: I need some document or manual (preferably in Spanish) that explains rules on like programming a procedure stored so that their yield is optimal, like structuring it (for example, if he is better to do several procedures stored small or is better to do a procedure stored greater).

Also it interests to know to me as they are the values that must have the parameters of CREATE PROCEDURE so that the yield of the procedure is very good.

You know some document on manual optimization querys DB2 or good practices programming?

2. From a point of view of Systems or DBA: I need to know the impact that can have the fact to do many procedures stored, for example, What load or to that affects: to the DB2, host, the memory, to the CPU, etc? , it would be necessary to extend some type of hardware, for example, more hard disk, more memory, etc, as the yield of the procedures stored from the point of view of systems can be improved.

My main interest is that the yield of the stored procedures that we program is very good since they will be used in applications Web that will be able to execute many users simultaneously.

If you have some document that can consult you it would thank for it very many.

Thank you very much
Back to top
View user's profile Send private message

syed-1919

New User


Joined: 26 Oct 2006
Posts: 12
Location: Chennai

PostPosted: Fri Dec 01, 2006 10:36 am    Post subject: Re: Help about stores procedures
Reply with quote

Hi angelalpe,

I would be able to help u in a better way, if you can give the following details,

1. The programming language that u would be using for application develoment.
2. If C/C++ (or simialr), what interface u would use (CLI/ODBC).
3. If JAVA (or simial), what interface u would use (SQLJ/JDBC).

Thanks & Regards,
Syed-1919
Back to top
View user's profile Send private message
angelalpe
Warnings : 1

New User


Joined: 22 Sep 2005
Posts: 32

PostPosted: Fri Dec 01, 2006 1:53 pm    Post subject: Need Help about stored procedures
Reply with quote

Hi,

The language is PL/I and the ODBC is STARTSQL

Thanks.
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 Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 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 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 6 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


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