Re: "create or replace" a stored procedure or a trigger

mdaponte@my-dejanews.com wrote: > > Is there a way to "create or replace" a stored procedure or a trigger? > > I need to develop about 300 triggers & SP and when an error happen it's a > pain to drop the trigger and then recreate it > > Thanks in advance > > -- > Manuel A. Daponte Santiago (mdaponte@prtc.net) > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum No, but you could create them all first, containing some really simple bug-free code, so you know they exist. Then you precede your real CREATE PROCEDURE code with DROP PROCEDURE myproc. What seems to be required is ALTER PROCEDURE. But, this would require the existence of the procedure first for consistency with the rest of SQL. Perhaps the current system is not so bad. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/