Generating the Information Schema Views

hello all can someone point me to where i find info on Generating the Information Schema Views / Accessing them ,etc in the docs? i would like to know any experiences anyone has had with it.....is it complex to turn on? is it much overhead? pros? cons? thanks in advance tom

tomcaml@yahoo.com wrote: > hello all > > > can someone point me to where i find info on Generating the Information > Schema Views / Accessing them ,etc in the docs? > i would like to know any experiences anyone has had with it.....is it > complex to turn on? is it much overhead? pros? cons? > thanks in advance By schema views do you mean "How can I print out the DDL needed to replicate and/or understand the database's schema?" or "How do I define multiple schema which are specific to a user or set of users like Oracle uses?". If the latter, in Oracle you can only have one database in a single server instance. In order to store multiple, user specific, data schema in a single server instance, Oracle creates a 'schema' with independent sets of tables and permissions. The same thing in Informix is accomplished by creating independent databases since a single Informix instance can manage dozens or even hundreds of separate databases with their own priveleges. Art S. Kagel

tomcaml@yahoo.com wrote: > can someone point me to where i find info on Generating the Information > Schema Views / Accessing them ,etc in the docs? > i would like to know any experiences anyone has had with it.....is it > complex to turn on? is it much overhead? pros? cons? dbaccess yourdbs $INFORMIXDIR/etc/xpg4_is.sql It's a fairly ancient version of the Information Schema, but it's there. For a more modern version, go to ISO/IEC 9075-11:2003 (SQL/Schemata) to see the requirements. Implementing them is a bit harder - to be polite about it. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/