Hey John,
So, you are running DB2 UDB, version 8.2 on Windows, also! Below is
how I move SQL Stored Procedures and Functions from Sourcesafe to the
Production database.


FUNCTIONS

1. Go to Sourcesafe and get the latest version of the applicable
function
2. Open up the DB2 Command Editor on the Production server
3. Paste the code from Step #1 in the Command Editor
4. Click the Execute (green) arrow


PROCEDURES

1. Go to Sourcesafe and get the latest version of the applicable
procedure
2. Open up the DB2 Command Editor on the Production server
3. Paste the code from Step #1 in the Command Editor
4. At the bottom of the Command Editor, change the "Statement
termination character" from a semicolon(;) to an exclamation point(!)
5. Click the Execute (green) arrow
6. After successful deploying of the stored procedure, change the
"Statement termination character" back to a semicolon(;)


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