Re: How do I get a list of stored procedures in my database?
Posted in 1999
Scott Kolaya — — source: Informix-list mailing list archive (1991-1998)
also try :
open the database you would like to list the procedures in,
Select procname from sysprocedures;
That table is in every database you create.
Scott
WF Software wrote in message ...
>In article <787p3b$t55$1@news.xmission.com>, david.tamburin@protegrity.com
>(David Tamburin) wrote:
>
>>
>> How do I get a list of stored proceedures in my database?
>> Someplace in the sysmaster I would think.
>> Thanks
>> david.tamburin@protegrity.com
>>
>Try
>
>dbschema -d <database> -f all>
>I remember it as the F-All command but I'm a bit odd somedays
>
>Paul Watson # I don't suffer from
>WF Software Ltd. # stress, I'm just
>Tel. (+44) 1436 674729 # a carrier
>Fax. (+44) 1436 678693 #
>www.wfsoftware.co.uk