Re: Access Tables from Different Database

Hi, purely from a 4gl perspective, little esql/c here, anyways, sql queries can reference other databases suchlike: database internal; select * from sysmaster:systables; the database name is prepended to the table name, works fine on inserts, one caveat, doesn't work too well with temp tables, and dont have the logging modes different on the databases brett In article <39922D46.B31B6A9B@hotmail.com>, kmlow72@hotmail.com says... > Hi all, > > I'm trying to write a program which works with 2 databases and has the > following algorithms. Could you please give some leads to me on how to > code this in Informix ESQL/C. As I understands that we cannot open > connection for 2 database simultenaously. Please advise. > > 1. foreach entry in "Table A" from "Database 1" > 1.1 derive new values based on "Table A".columns > 1.2 update/insert new values derived from (b) into "Table B" in > "Database 2" > > Do you think create VIEWs will helps, just my curiosity? > > Have a nice day, > kitming > > >