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]

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