Re: Stored procs and system tables

Michael dbschema -f all database_name create_procs.sql will send all CREATE PROCEDUREs into create_procs.sql. And the SQL: select "DROP PROCEDURE " || TRIM(procname) || ";" from sysprocedures where procname != "systdist"; will give you a the SQL for the procedures to drop. Sujit Michael Talbot <michael.talbot@telops.gte.com> on 05/19/99 01:07:55 PM Please respond to Michael Talbot <michael.talbot@telops.gte.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Stored procs and system tables Is there a somewhat painless way to extract from the system tables all the drop and create statements for all user written procedures in a given database into a single text file . I am using Informix ODS 7.14 / HP-UX 10.2 TIA, Mike