Re: Creating generic routine to drop procedure

Wouldn't the simplest way be something like : drop procedure drop_proc; create procedure drop_proc(inproc char(200)) SYSTEM "/usr/local/bin/drop_proc.sh thisdbname " || inproc; end procedure; Then just write a shell script to do the drop, something like (called /usr/local/bin/drop_proc.sh in the SP above) : #!/bin/sh echo "drop procedure $2" | dbaccess "$1" - > /dev/null 2> /dev/null exit 0 On Monday 04 December 2006 20:56, Bhru wrote: > Hi I am trying to create a generic drop procedure routine. > Any help would be appreciated. > > Here is the code. > -- This is test procedure > CREATE DBA PROCEDURE btest() > RETURNING CHAR(1);> return 'Y'; > END PROCEDURE; > GRANT execute on btest to public;> > -- This procedure would delete the procedure name passed in param > CREATE DBA PROCEDURE test_gen_drop_pro (inpProcName varchar(200))> > IF EXISTS (select procname from sysprocedures where procname = > inpProcName) THEN > drop procedure inpProcName;> END IF; > END PROCEDURE; > EXECUTE PROCEDURE test_gen_drop_pro('btest'); > DROP PROCEDURE test_gen_drop_pro; > EXECUTE PROCEDURE btest();> > It still keeps btest procedure in database. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list -- Mike Aubury