RE: dbspace of non-fragmented tables
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.
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
==================================================================