Re: How do I get a list of stored proceedures in my database?

Posted in 1999

Octav Chiriac — Thu, 21 Jan 1999 19:37:23 +0200 — source: Informix-list mailing list archive (1991-1998)

Not in sysmaster. In the sysprocedures table in your database. Best Regards, Octav On Thu, Jan 21, 1999 at 12:21:06PM -0500, 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 -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com

↪ replying to Octav Chiriac

Dino Gomez — Thu, 21 Jan 1999 14:27:12 -0500 — source: Informix-list mailing list archive (1991-1998)

'sysprocedure' is right! BTW, you can get an ER diagram for 7.x system tables from IIUG Articles and Documentation (look under "Other Documentation and Files") Regards, -Dino Octav Chiriac wrote: > Not in sysmaster. In the sysprocedures table in your database. > > Best Regards, > Octav > > On Thu, Jan 21, 1999 at 12:21:06PM -0500, 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 > > -- > Octav Chiriac Phone: (373) 2 21 20 96 > NetInfo S.R.L. Fax: (373) 2 21 36 59 > Chisinau (373) 2 24 00 83 > Moldova, Republic of mailto:com@netinfo-moldova.com