Re: pseudo tables ...?

> Hi > > What is pseudo table .?. Some of the sysmaster tables are not real tables but views into Online shared memory (also called pseudo tables). > > isql reports an error 'table is not in this database ' if i > > select some of the tables listed in sysmaster database ... > > Where can i find info about these tables .?. They are somewhat documented in the Online Admin manuals. I just wrote an articule on this for our user group newsletter. It's at: Washington Area Informix User Group(WAIUG) Web Page Information. http://www.access.digex.net/~waiug Volume 6, No. 3 - July 1996 - Exploring the SYSMASTER Database (Part 1) - by Lester Knutsen - Informix Event Alarms, by Kevin Fennimore and Ivy Ho - Testing an Informix DBA, by Madhu Reddy - Informix Installation and OnLine Configuration Procedures, by Mike Tinius - WAIUG Web Pages and On-Line Newsletters, by Lester Knutsen - WAIUG History If you do not have web access, please let me know and I can email you a copy of it in text format. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # # Washington Area Informix User Group: http://www.access.digex.net/~waiug # #############################################################################