Re: List tables in dbspace through sysmaster query
This would not list any tables which are fragmented by "round robin",
"expression" because systables has it's partnum as zero.
So go back to the earlier posting of Vinod Bhansali and use that
In fact IIUG site also has got it wrong (incomplete) the same way.
Someone should go and correct 8.6.
Vivek Chaudhary
______________________________ Reply Separator _________________________________
Subject: Re: List tables in dbspace through sysmaster query
Author: a.blonde (a_blonde@mindless.com) at internet
Date: 5/19/00 4:54 AM
---- you wrote:
> Hi,
>
> I'm trying to find a way to list the tables located in a dbspace through a
> query
> against the sysmaster db. I'm sure it's possible, but I can't find a table
> in sysmaster
> containing the table to dbspace mapping. Anyone know how to list the
> tables in a specific
> dbspace through a query against the sysmaster database?
>
> Thanks,
>
> Jeff
>
> P.S. I am using informix 7.31UC5, I'm not sure if it matters.
You can use this Dude:
select dbsname, tabname
from systabnames
where dbinfo("dbspace", partnum) = "rootdbs"
AB
----------------------------------------------------------------
Get your free email from AltaVista at http://altavista.iname.com