Re: Multiple DB access

On Sun, 9 Nov 1997, Carlos Antonio Ruiz Gomez wrote: } > I am looking for a way, if at all possible, using a single 4gl program, } > to read a table from one Informix database and write to another Informix } > table sitting in a different db. } For Standard Engine I use the following commands: } DATABASE db1 } SELECT * FROM table_bd1 INTO TEMP tmp_tablebd1 WITH NO LOG } DATABASE db2 } -- Change database doesn't drop temp tables } INSERT INTO table_bd2 SELECT * FROM tmp_tablebd1 Beware - this is a bug that is being exploited. The bug was fixed in at least one version; the fix may have been backed out due to the outcry of fustrated users, but it can never be anything other than a horrendous kludge and bug. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>