Bug in dbschema?
Informix Dynamic Server Version 7.30.UC5 , Unix
When I do a dbschema using the -ss option it shows the dbspaces for the
indexes but not the table. Is this a bug?
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Dbschema will not output the dbspaces if the tables or indexes were created
in the same dbspace as the database itself.
If indexes or tables are created in a different dbspace other than where the
database was created then the dbspace will appear.
Lloyd AJ Wilson
strangiato@my-deja.com wrote in message <7s60er$u4g$1@nnrp1.deja.com>...
>Informix Dynamic Server Version 7.30.UC5 , Unix
>
>When I do a dbschema using the -ss option it shows the dbspaces for the
>indexes but not the table. Is this a bug?
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
strangiato@my-deja.com wrote:
>
> Informix Dynamic Server Version 7.30.UC5 , Unix
>
> When I do a dbschema using the -ss option it shows the dbspaces for the
> indexes but not the table. Is this a bug?
dbschema -ss does not report dbspaces for objects that live in thedatabase's default dbspace. If you want this functionality get
myschema.ec which is part of my package utils2_ak in the IIUG Software
Repository. It ALWAYS reports dbspace for all objects and has many other
nice features for people who actually USE their schema files rather than
just save them as documentation.
Art S. Kagel