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

Michael Talbot wrote: > > 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 You can use "dbschema -d database -f all" or get myschema.ec from my submission, utils2_ak, in the IIUG Software Repository, which does all that dbschema does and MUCH more. BTW the latest version of utils2_ak with a new version of myschema is available as of yesterday. It includes a few bug fixes and new features, also the dbload script generation mode has been updated to work with 7.xx dbload. Also myschema now optionally generates the talbe statistics comment ala dbschema (but it gets the index sizes right unlike dbschema - bug #111832). Art S. Kagel