Hi all.

I´m trying to do a recursive SP in db2 studio, does anybody know how to do it? When I deploy it send me an error 'cauze in the deploy drop the procedure so when it's refer to itself doesn't find it.

Thanks.
Best regards.

Use dynamic SQL to call the procedure, or set the database configuration parameter AUTO_REVAL to DEFERRED_FORCE

Look here:

V8 WinNT: Compiling recursive stored procedures

Andy

Thanks a lot, the information was very useful.

Regards.