Oninit cdi / Archive
Talk to an expert →

Dropping a procedure.

Posted in 2005

Topics: General Discussion

Andrew Hardy — — source: Usenet: comp.databases.informix

Can any-one tell me how I drtrop a procedure in informix? Andrew H sending to informix-list

↪ replying to Andrew Hardy
June C. Hunt — — source: Usenet: comp.databases.informix

"Andrew Hardy" wrote: > > Can any-one tell me how I drtrop a procedure in informix? DROP PROCEDURE <procedure_name> You must either be the owner of the procedure or have DBA privileges. If you are taking advantage of routine overloading and have not created the procedure(s) with a 'SPECIFIC' name, then you will have to also supply a list of the input parameter data types. For example: DROP PROCEDURE my_proc(int, int); If you are not sure what the parameters are, you can query the sysprocedures table for details. See the Guide to SQL: Syntax and Reference for more on this. http://www-306.ibm.com/software/data/informix/pubs/library/lists.html -- June Hunt

Related threads