On Tue, 05 Aug 2003, MAX wrote:
> is there the equivalent of a create OR REPLACE store proc ?
> or "if stored proc X exists then drop proc X" ?
In pure SQL I think you cannot do it (correct me if I'm wrong).
But as soon as you're in a procedure and therefore can use
"if" statements, try something like:
IF (SELECT COUNT(*)
FROM DOMAIN.DBPROCEDURES
WHERE DBPROCNAME = UCASE('theonetodelete'))
THEN
DROP DBPROC theonetodelete
;
Christian
--
--
COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test
--------------------------------------------------
1. GMX TopMail - Platz 1 und Testsieger!
2. GMX ProMail - Platz 2 und Preis-Qualit�tssieger!
3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
