CREATE or REPLACE PROCEDURE

Posted in 2010

Topics: General Discussion

WALDEMAR ZNOINSKI — Thu, 19 Aug 2010 09:04:06 — source: IIUG Forums & Mailing Lists

Hi there, did anyone meet something like Informix equivalent of DB2's CREATE or REPLACE PROCEDURE?

↪ replying to WALDEMAR ZNOINSKI

JACK PAPA — Thu, 19 Aug 2010 14:00:28 — source: IIUG Forums & Mailing Lists

You need to drop the old procedure and just do "create procedure procname".

↪ replying to WALDEMAR ZNOINSKI

Art Kagel — Thu, 19 Aug 2010 17:33:25 — source: IIUG Forums & Mailing Lists

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

↪ replying to Art Kagel

WALDEMAR ZNOINSKI — Fri, 20 Aug 2010 09:57:09 — source: IIUG Forums & Mailing Lists

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 :-)