Re: Urgent, tables in dbspaces

Posted in 1999

Sujit.Pal@bankofamerica.com — Mon, 19 Jul 1999 09:58:28 -0700 — source: Informix-list mailing list archive (1991-1998)

dragon Try this: select tabname, dbinfo('DBSPACE', hex(partnum)) from systables where tabid > 99 and tabtype = "T" HTH Sujit 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