Multiple databases in Perform

A couple weeks ago I wrote: Is there any way to do a lookup to a different database in a Perform screen? I have tried numerous ways with most of them involving following the 2nd database with a colon (y:table.column). Since I can do it in Ace I thought there had to be a way in Perform. I'm using 4.1 and 5.0 online. To which I got a direct reply from Jonathan Leffler: No direct way -- create an synonym in the database for the remote table and it should work. To which I replied directly to him thanking him profusely for such a simple and elegant solution. Again, Jonathan replied directly: Glad to be of some assistance. Thinking about it some more, you may be able to do: TABLES localalias = somedb@someserver:'someuser'.sometable ... ATTRIBUTES f000 = localalias.somecolumn, ...; That is, you may not need to create a permanent synonym in the database. I don't think there's a way to control the display attributes of the subject of a LOOKUP clause. - - - - - - - - So now that I have you all on the edge of your seats, here is the new problem. I created the synonym and my lookup ran great. DATABASE student; CREATE SYNONYM sn FOR gradsch:studname But, when I do my backup via cron I also check the integerity of my databases; tbcheck -cI -cD -q student STUDENT - CHECK TABLE INDEXES AND ROWIDS IN INDEX; CHECK TBLSPACE DATA ROWS INCLUDING BITMAPS, REMAINING PAGES AND BLOBS: WARNING:No syscolauth records found. I don't know ISAM error: no record found. what to doERROR: No table found for syssynonyms record. about any of Tabid 192 these Server name messages. Or Database name gradsch why I got them. Owner informix We have never Table name studname used synonyms Tabid of base table -2147483648 before. tbcheck -cI -cD -q gradsch GRADSCH - CHECK TABLE INDEXES AND ROWIDS IN INDEX; CHECK TBLSPACE DATA ROWS INCLUDING BITMAPS, REMAINING PAGES AND BLOBS: WARNING:No syscolauth records found. WARNING:No sysdepend records found. WARNING:No syssyntable records found. WARNING:No sysviews records found. tbcheck -cc CHECK DATABASE CATALOGS: tbcheck -ce -q CHECK TBLSPACE EXTENTS AND CHUNCK EXTENTS: WARNING:TBLSpace student:informix.cond has more than 8 extents. WARNING:TBLSpace student:informix.srop has more than 8 extents. WARNING:TBLSpace student:informix.petfiled has more than 8 extents. WARNING:TBLSpace gradsch:informix.fellowpres has more than 8 extents. WARNING:TBLSpace gradsch:informix.studname has more than 8 extents. WARNING:TBLSpace gradsch:informix.snaplog has more than 8 extents. tbcheck -cr -q CHECK RESERVED PAGES: I know I need to do something about the 8 tables that have more than 8 extents although opinions on this bulletin board seems mixed. ~