RE: How do I get a list of stored proceedures in my database?
This is a multipart message in MIME format
--------------InterScan_NT_MIME_Boundary
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
you can view the stored procedures using dbschema utility
The syntax is dbschema -d your_database_name -f all =20
A.U.S. Dar=EDo J. Yossen
Administraci=F3n de Bases de Datos
Dpto. Tecnolog=EDa - Gcia. de Sistemas
Aguas Provinciales de Santa Fe
Tel: 54 - 42 - 504035/ 504110
E-Mail: dyossen@apsf.com.ar =20
> -----Mensaje original-----
> De: Dino Gomez [SMTP:gomezd@ms.com]
> Enviado el: Jueves 21 de Enero de 1999 16:27
> Para: informix-list@iiug.org
> Asunto: Re: How do I get a list of stored proceedures in my
> database?
>=20
> This is a multi-part message in MIME format.
> --------------13698A0E3BBC1AF122846555
> Content-Type: multipart/alternative;
> boundary=3D"------------2A81897F3D50EA51CE0348C7"
>=20
>=20
> --------------2A81897F3D50EA51CE0348C7
> Content-Type: text/plain; charset=3Dus-ascii
> Content-Transfer-Encoding: 7bit
>=20
> '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")
>=20
> Regards,
> -Dino
>=20
> Octav Chiriac wrote:
>=20
> > 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
>=20
> --------------2A81897F3D50EA51CE0348C7
> Content-Type: text/html; charset=3Dus-ascii
> Content-Transfer-Encoding: 7bit
>=20
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML>
> 'sysprocedure' is right! BTW, you can get an ER diagram for 7.x
> system
> tables from <A
> HREF=3D"http://www.iiug.org/techinfo/articles/articles_top.html">IIUG
> Articles and Documentation</A> (look under "Other Documentation
> and
> Files")
> <P>Regards,
> <BR>-Dino
> <P>Octav Chiriac wrote:
> <BLOCKQUOTE TYPE=3DCITE>Not in sysmaster. In the sysprocedures table =
in
> your
> database.
> <P>Best Regards,
> <BR>Octav
> <P>On Thu, Jan 21, 1999 at 12:21:06PM -0500, David Tamburin wrote:
> <BR>> How do I get a list of stored proceedures in my database?
> <BR>> Someplace in the sysmaster I would think.
> <BR>> Thanks
> <BR>> david.tamburin@protegrity.com
> <P>--
> <BR>Octav
> =
Chiriac &nb
> =
sp; &
> nbsp;
> Phone: (373) 2 21 20 96
> <BR>NetInfo
> =
S.R.L. &nbs
> =
p; &n
> bsp;
> Fax: (373) 2 21 36 59
> =
<BR>Chisinau &nbs
> =
p; &n
> =
bsp;
>
> (373) 2 24 00 83
> <BR>Moldova, Republic
> =
of &n
> bsp;
>=20
> <A
> =
HREF=3D"mailto:com@netinfo-moldova.com">mailto:com@netinfo-moldova.com</=
> A></BLOCKQUOTE>
> </HTML>
>=20
> --------------2A81897F3D50EA51CE0348C7--
>=20
> --------------13698A0E3BBC1AF122846555
> Content-Type: text/x-vcard; charset=3Dus-ascii; name=3D"vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Dino Gomez
> Content-Disposition: attachment; filename=3D"vcard.vcf"
>=20
> begin: vcard
> fn: Dino Gomez
> n: Gomez;Dino
> org: Morgan Stanley Dean Witter
> adr;dom: 1221 Ave. of the Americas (5th Flr.);;;New
> York;NY;10020;
> email;internet: gomezd@ms.com
> title: Associate
> tel;work: 1-212-762-8795
> tel;fax: 1-212-762-7460
> x-mozilla-cpt: ;0
> x-mozilla-html: FALSE
> version: 2.1
> end: vcard
>=20
>=20
> --------------13698A0E3BBC1AF122846555--
--------------InterScan_NT_MIME_Boundary--