Finding Tables through SMI

Posted in 1998

Audie Wright — Mon, 04 May 1998 20:17:22 GMT — source: Informix-list mailing list archive (1991-1998)

ALL: I am interested in finding what dbspace a specific table resides in through using SQL against the sysmaster database. For each tabname, I would like to list the dbspace name in the results. Here is my current query that I am developing. select systabnames.dbsname, systabnames.tabname, sysptnhdr.nrows, sysptnhdr.nptotal, sysptnhdr.npused, sysptnhdr.npdata, sysptnhdr.fextsiz, sysptnhdr.nextsiz from systabnames, sysptnhdr where systabnames.partnum = sysptnhdr.partnum group by systabnames.dbsname, systabnames.tabname, sysptnhdr.nrows, sysptnhdr.nptotal, sysptnhdr.npused, sysptnhdr.npdata, sysptnhdr.fextsiz, sysptnhdr.nextsiz order by systabnames.dbsname, systabnames.tabname Audie Wright ----------------------------------------------------- DBA / Programmer Pegasus Systems Web: http://pegasus.thisco.com Email: audiew@thisco.com Phone: 214-523-9209