Re: dbspace of non-fragmented tables
How about:
database sysmaster;
select dbs.name dbspace_name, dbsname dbase_name, tabname tab_name
from sysdbspaces dbs, sysptprof
where trunc(partnum/1048576) = dbs.dbsnum
and dbsname = "<database name>"
and tabname = '<table name>'
John Carlson
Informix DBA
WHSmith USA
Toine Schijvenaars wrote:
>
> Indeed, I'm sorry I forgot to mention this. What we need is some SQL statement
> from the sysmaster database, because we have to determine it dynamically.
>
> Chuck Renaud wrote:
>
> > Only if the table wasn't created with an IN clause...
> >
> > > The table will be in the same dbspace as the database in which it resides.
> > > To get that information, go to dbaccess and choose
> > > Database...Info...dBspace.
> > >
> > > -----Original Message-----
> > > From: Toine Schijvenaars [mailto:tsch00@solair1.inter.nl.net]
> > > Sent: Wednesday, April 28, 1999 9:36 AM
> > > To: informix-list@iiug.org
> > > Subject: dbspace of non-fragmented tables
> > >
> > >
> > > How can I determine the dbspace in which a certain table is allocated if
> > > this table is not fragmented.
>
> --
> ==================================================================
> Drs. Toine Schijvenaars Baron van Nagellstraat 136A
> System Development Postbus 113
> Roccade Public 3770 AC Barneveld
> mobiel: 06 51 28 29 47 tel: 0342 403693
> e-mail: tsch00@solair1.inter.nl.net fax: 0342 403400
> ==================================================================