Re: Urgent, tables in dbspaces

Posted in 1999

Vijaya Erabell — Mon, 19 Jul 1999 10:12:41 -0600 — source: Informix-list mailing list archive (1991-1998)

Try this sql: select t.tabname table, d.name dbspace from systables t, sysmaster:sysdbspaces d where tabid > 99 and d.dbsnum = trunc(t.partnum/1048576); Hope this helps, Vijaya. ------------------------ From: dragon dragon <dragonmanyana@hotmail.com> Subject: Urgent, tables in dbspaces Date: Mon, 19 Jul 1999 14:52:40 GMT To: informix-list@iiug.org 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 ---------------End of Original Message-----------------