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/