Re: in search of Informix metadata

Jesse said: > Hi all, > > I have a few questions about Informix that I haven't been able to > answer in web searches. I am using 9.5 but I'm interested in the > answers for earlier versions as well. 9.4, surely? :o) > 1. is there a standard way to store metadata about objects with > informix? In SQL Server there is the notion of extended properties, > and other DBMS use other methods, such as the ALL_TAB_COMMENTS in > Oracle, etc. Is there something similar with Informix? Not that I know of. > 2. are dependencies between procs and functions, and the tables/views > they target stored by the server? There is the sysdepend table, but > it seems only to track dependencies of views on tables. Not that I know of, but I could easily be wrong. > 3. Is there a way, using a tool or via SQL to generate the DDL for all > database objects in an existing db? I am aware of sysprocbody, > systrigbody, and sysviews for procs, triggers, and views. But what > about tables, indexes, etc? Any way to generate the DDL for them? systables, sysindexes? Look at the dbschema command. > 4. Is there a system catalog table that stores info about proc/ > function parameters? I'm hoping for something akin to > INFORMATION_SCHEMA.PARAMETERS. Pass. > All of this is in regard to an app I have built (SqlSpec) that will > document a schema for any database on all major DBMS. I am currently > in the process of adding Informix support for it. You can check it > out here if you are interested: http://www.elsasoft.org. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo "Cluster in my trousers" -- Guy Bowerman -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.