CREATE or REPLACE PROCEDURE
Waldemar Znoinski asked for an Informix equivalent of DB2's CREATE OR REPLACE PROCEDURE. Jack Papa said to drop the old procedure and create it again; Art Kagel confirmed the feature does not exist in current releases. Waldemar said they would drop the procedure when ON EXCEPTION is raised.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi there, did anyone meet something like Informix equivalent of DB2's CREATE or REPLACE PROCEDURE?
You need to drop the old procedure and just do "create procedure procname".
This features is not available in the current releases of Informix. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Aug 19, 2010 at 5:04 AM, WALDEMAR ZNOINSKI <waldek@znoinski.pl>wrote: > Hi there, > did anyone meet something like Informix equivalent of DB2's CREATE or > REPLACE > PROCEDURE? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e6471ada150045048e308a92
hey there, thanks Art - I needed that confirmation, thanks to our support we drop it when ON EXCEPTION is raised - sometimes the simpliest things are the last to think of :-)