If you are using the Command Editor to create the Stored Procedure, you need to change the statement delimiter character. The default is the semicolon which will not work for stored procedures. The entire CREATE PROCEDURE is just one statement to DB2. All of the internal sql statements are still part of the CREATE PROCEDURE statement, so the semicolon on those are need and thus a different character is need for the CREATE PROCEDURE statement. If you leave it at the default value, you get the error you are getting because DB2 thinks the entire CREATE PROCEDURE statement ends at the first semicolon.

Andy