Hi All:

I have created a Stored Procedure directly from the Command Window. It
is OK and when I invoke it, everything is OK. But I don't see it on the
Control Center. (BD-> App.Obj -> Stored Procedures) I try to refresh,
quit from Control Center, but still Control Center doesn't show my SP.
I have DB2 V8.1 for Windows.

Any Ideas? Thanks...!

experienced the same problem in DB2 Version 8.1 Personal Edition for windows. i created the procedure through DB2 command window, the same is not listed in DB2 Control center. Procedure name which i had created is more than 18 characters.
And my question is, whether length of the procedure name is problem with this one?

help

Can you post your stored procedure here exactly as you typed it into command centre together with exact failed compile message you received please

Thanks

Hello:
Here is the code. Is quite simple.

CREATE PROCEDURE DRR.PROCEDURE1 (INOUT var0 varchar(50) )
LANGUAGE SQL

P1: BEGIN
DECLARE cursor1 CURSOR WITH RETURN FOR
Select ope_nombre from preventa.prvoperadores;
END P1