in search of Informix metadata
Posted in 2007
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. 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? 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. 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? 4. Is there a system catalog table that stores info about proc/ function parameters? I'm hoping for something akin to INFORMATION_SCHEMA.PARAMETERS. 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. Thanks, Jesse