>Hi, Informix SQL Gurus:
>I have the following questions:
>Our application is migrating from Informix On-Line to Informix SE.
>In our application, I need to create a joined table from tables in
>DIFFERENT databases, using ESQL/C. This could be easily done with
>ON_LINE engine which allowes opening multiple databases at the same time.
>Howere, Informix SE can open only one databases at a time. Is there a way
>to fix the problem. Any hint will be appreciated.
Here's one solution -. What follows in part of a 4gl program
# First, select the first Database
# Unload the table
UNLOAD TO junk.dat
SELECT * FROM db_one_table
..Add where clause if possible
# Select the second database
# Load the data into a table of identical structure (or create temp table..)
LOAD FROM junk.dat
INSERT INTO db_two_table
# Now, query away.
Hope this helps,