Re: querying against multiple SE DBs

In article <848350447.21893@dejanews.com>, stelter@tellabs.com writes >Has anyone run a query against more than one standard engine databases? > >We have Informix-SE 7.12.UC1 running on a Sun/Solaris server. > >The suggestion we received from tech support was to run the query >on the first db and save the output to an ascii file and do the >same on the second db - and then load both ascii files into a third >dummy database and then do sorting and calculations there. > >We are looking for something that's a little more efficient than that. > >I see in the manuals that on-line has syntax like > >SELECT * >FROM db1:table1,db2:table2.>... > >Is there anything like this for SE? > >Any suggestions you have would be greatly appreciated. > >Thanks > >Sandy Pohovey >stelter@tellabs.com >----------------------------------------------------------------------- >This article was posted to Usenet via the Posting Service at Deja News: >http://www.dejanews.com/ [Search, Post, and Read Usenet News] Yes but you need SE 7.1. I believe. -- David Williams