Re: ESQL problems in migration from ON-LINE to SE

> 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. I assume you want to join across servers for a query. You might be able to create a synonym for your remote table(s) in your local database. Install Informix-NET, and you _should_ be on your way. Alternatively, you can hit your remote database, query your join table into a temp table, connect to your local db and the temp table will still be there. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | (E) billy@west.co.za (U) http://www.west.co.za/billy.html | +------------------------------------------------------------------------------+ | WARNING: sending me junk-email will be interpreted as granting permission to | | bomb your offices and machine-gun your children. | +------------------------------------------------------------------------------+