Re: How to access TEMP tables using SE 5.0x and I-NET

Does SE 5.0x engine support distriubutive data ?. I do not think so. But it has been a long time since I worked on SE 5.x engine. -- Rajiv Jhaveri DBA ============================================================= Voice : (908) 949 7987 Pager : 544 7872 Fax : (908) 949 1726 E-mail: rajivp@qsun.ho.att.com ============================================================= } From rmy.emory.edu!informix-list-owner@cbig3.att.att.com Tue Jun 11 16:22:02 1996 } >Received: by cbgw3.att.com; Tue Jun 11 16:18 EDT 1996 } From: noblesys@atl.mindspring.com (Noble Systems Corporation) } Subject: How to access TEMP tables using SE 5.0x and I-NET } Sender: informix-list-owner@rmy.emory.edu } To: informix-list@rmy.emory.edu } X-Informix-List-To: rajivp@qsun.ho.att.com } X-Informix-List-Id: <news.24874> } Content-Type: text } } Big problem for us. } } We are using Informix 5.0x SE engine and I-NET and TOOLS. Our 4gl } programs use TEMP tables that need to be accessed while in different } databases. When we deployed I-NET to distribute the processing, we can } no longer see the temp tables over databases that span multiple } machines. } } For instance: } } Machine A has a database named "test" , Machine B has a database named } "test2". The DBPATH is setup correctly to see both databases and the } 4GL programs can access both databases correctly. However, if we } create a TEMP table on "test" and switch to "test2" and try to select } from that TEMP table, we get the "table does not exist in database" } error. } } If both databases are on the same machine, the above works fine. } } Informix support has told us that SE 5.0x should support this. } } Has anyone else done this or know if it is indeed possible? Or, } alternatively, what is the best workaround? } } Any help would be greatly appreciated. } } TIA, } } }