take a look in the sqllib/samples/sqlproc directory and follow the
instructions on the README

basecase.db2 is a simple SP

db2 -[Email Address Removed] -vf basecase.db2 will build it

and there are instructions inside it on how to invoke.






"Edwards Ed "
<db2udbdba-ezmlms
hield-x47626790.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
05/30/2006 12:27
PM Subject
DB2 Code - Functions and Procedures










To All,
We are moving some of our DB2 version 7 databases from the mainframe
(ZOS, OS/390) to an IBM server running Windows 2003 using DB2 version 8.2.
We have never created functions or procedures in the DB2 database. But you
know these "developers" (Oh my! Phew!); they just might want to do that!
hehe.

My question is: Does anyone have an example for creating a simple
function and a simple procedure in the DB2 version 8.2 database for Windows
and how to execute them? Thanks.


Please take a few minutes to provide feedback on the quality of service you
received. The Department of Education values your feedback as a customer.
Commissioner John L. Winn is committed to continuously assessing and
improving the level and quality of services provided to you by Department
staff. Simply use the link below. Thank you in advance for completing the
survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page