Re: Urgent, tables in dbspaces

> >Try this: > >select tabname, dbinfo('DBSPACE', hex(partnum)) >from systables >where tabid > 99 >and tabtype = "T"> >HTH >Sujit It's ok thinks, it works and I think that I can do it without using hex, I mean : select tabname,dbinfo('DBSPACE',partnum) from ... The unique problem that subsiste is when I want to order the result, (order by 2), it give me a error of using dbinfo >dragon dragon <dragonmanyana@hotmail.com> on 07/19/99 07:52:40 AM > >To: informix-list@iiug.org >cc: (bcc: Sujit Pal) >Subject: Urgent, tables in dbspaces > > > > >Please could any one give me a query (from catalog system or DB sysmasters) >to find tables resident in each dbspace. >think you. > > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > > > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com