querying against multiple SE DBs

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]