Re: Stored procs and system tables

Hi ! Sorry i just overlooked this mail, I have another question on this. Is there aany way that you can get all the procedures / table schema by giving some filter conditions. I have given the names of tables/procedures/triggers on sub-module names like "tm_t_table1" - for Table belonging to TM Module "sm_t_table2" - for Table belonging to SM Module Similarly for procedures .. "tm_sp_proc1" for proc of TM "sm_sp_proc2" for proc of SM Is there any way that i can only get table/proc schema of tables of one module. Otherwise there are more than 2000 table and > 1000 procedures whereas my need is only of 220 tables and 161 procs TIA, Nayan ! On Wed, 19 May 1999, Art S. Kagel wrote: > 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 >