Re: Question on multiple databases.

dana wrote: > Back again with a question on connnecting to multiple databases. I am > working on an older system (4.01) which has 4 mirrored databases that > are not syncronized. Each instance of the database is a unique SQL Turbo > and to access the different databases the environment has to be changed. > To change databases TBCONFIG has to point to a different config file... > TBCONFIG=tbconDB1, TBCONFIG=tbconDB2 etc... > I need to collect data from all 4 databases and store in a new instance > of a database. I cannot do a remote select because each instance is its > own Turbo. Is there any way to start a 4gl program and switch > environments without loosing the program thread? Any help on this would > be very much appreciated... > Dana I can think of several possible ways of doing this. I'd probably connect to each database in turn, unload the data to text files, and finally connect to the fifth database and load everything. And I'd try to avoid using I4GL, unless there is some extra processing to be done that cannot be done by DB-Access (or SQLCMD). Of course, one could also point out that one of the advantages of keeping more or less up to date is that you would be able to use multiple connections much more easily. And, also, you are aware that 4.x databases are no longer supported, and that they are not officially Y2K-compliant (though you'll be OK as long as you always, but always, show all 4 digits for the year). And you might want to worry about your backups starting in, oh, 25 days. I don't know that there are any problems with the 4.x backups, but I certainly don't know that you'll be able to recover safely either. You have done your own Y2K sanity testing haven't you? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>