Re: URGENT: STORED PROCEDURES CODE

Posted in 1999

Javier Puente — Mon, 08 Mar 1999 14:48:03 -0500 — source: Informix-list mailing list archive (1991-1998)

By the way, all the information of stored procedure is manages by the tables: sysprocedures sysprocbody You can query them, for additional information Regards JPG Sujit.Pal@BankAmerica.com wrote: > ASC > > dbschema -d database_name -f all all_my_procs.sql> > will give you the source for all your SPs. > > HTH > > Sujit > > ASC <i52sacaa@uco.es> on 03/08/99 01:38:43 AM > > Please respond to ASC <i52sacaa@uco.es> > > To: informix-list@iiug.org > cc: (bcc: Sujit Pal) > Subject: URGENT: STORED PROCEDURES CODE > > Can be recovered the code of stored procedures in a database, I > mean, I don?t have an updated verision of the procedures source code and > want to view it from the compiled procs. Can this be done? And how? The > server is Online Dynamic Server 7.2 > Thank you.

↪ replying to Javier Puente

Art S. Kagel — Tue, 09 Mar 1999 16:07:35 -0500 — source: Informix-list mailing list archive (1991-1998)

Javier Puente wrote: > > By the way, all the information of stored procedure is manages by the > tables: > > sysprocedures > sysprocbody Not to snub sysprocauth. Art S. Kagel