Re: table location

Phillip Try SELECT DBINFO('dbspace', HEX(partnum)), tabname FROM systables WHERE tabid > 99; HTH Sujit tienp@wholefoods.com on 06/01/2000 11:03:37 AM Please respond to tienp@wholefoods.com To: informix-list@iiug.org cc: Subject: table location --------------15BF21438D382ED6D84ACA03 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit How do you find out which dbspace a table resides in? For example, I have a database that resides in db0, but I have database tables x, y, and z that are in db1, db2, and db3, but I don't know which is in which. These tables are not fragmented so an entire table resides in a dbspace. And please don't say check the system catalogs (sysfragments, systables) because I've done that. I'm looking for actual syntax, be it SQL or some oncheck parameter I'm not familiar with that will give me this info. Please copy any replies to: tienp@wholefoods.com. Thanks. -- Phillip --------------15BF21438D382ED6D84ACA03 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> How do you find out which dbspace a table resides in?&nbsp; For example, I have a database that resides in db0, but I have database tables x, y, and z that are in db1, db2, and db3, but I don't know which is in which.&nbsp; These tables are not fragmented so an entire table resides in a dbspace.&nbsp; And please don't say check the system catalogs (sysfragments, systables) because I've done that.&nbsp; I'm looking for actual syntax, be it SQL or some oncheck parameter I'm not familiar with that will give me this info.&nbsp; Please copy any replies to:&nbsp; <a href="mailto:phillip.tien@wholefoods.com">tienp@wholefoods.com</a>.&nbsp; Thanks. <p>-- <br>Phillip <br>&nbsp;</html> --------------15BF21438D382ED6D84ACA03--