DROP PROCEDURE proc-name as TFM says !!!

-> -----Original Message-----
-> From: Andrew Hardy [mailto:Andrew.Hardy@marconi.com]
-> Sent: Thursday, April 28, 2005 10:56 AM
-> To: informix-list@iiug.org
-> Subject: Dropping a procedure.
->
->
-> Can any-one tell me how I drtrop a procedure in informix?
->
-> Andrew H
->
->
-> sending to informix-list
->

**********************************************************************************
This message is sent in strict confidence for the addressee only.  It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
**********************************************************************************

sending to informix-list

Hello

From
dbaccess YOUR_DATABASE
New query
Drop procedure PROCEDURE_NAME;

Bye

Andres F .Troncoso

IBM Certified Solutions Expert -- Informix Dynamic Server V9 System
Administrator
IBM Certified Solution Designer -- DB2 Business Intelligence V8

IBM Advanced Business Partner
       Information Management Software
       Informix Specialists

----- Original Message -----
From: "Andrew Hardy" <Andrew.Hardy@marconi.com>
To: <informix-list@iiug.org>
Sent: Thursday, April 28, 2005 4:55 AM
Subject: Dropping a procedure.

sending to informix-list

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

--0-2102275832-1114703511=:73850
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

How I can disable a specific trigger of 'x' table?
Regards,

---------------------------------
Do You Yahoo!?
Yahoo! Net: La mejor conexión a internet y 2GB en tu buzón de Correo Yahoo! por $100 al mes.

--0-2102275832-1114703511=:73850
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<P>How I can&nbsp;disable a specific trigger of 'x' table?
<P>Regards,</P></BLOCKQUOTE></DIV><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://net.yahoo.com.mx"><b>Yahoo! Net</b></a>: La mejor conexión a internet y 2GB en tu buzón de Correo Yahoo! por
<a href="http://net.yahoo.com.mx/">$100 al mes</a>.<br>
--0-2102275832-1114703511=:73850--
sending to informix-list