Re: Informix & Ingres coresident app's

Alan Popiel writes: >Corinne Gregory had written: >->Subject: Informix & Ingres coresident app's >-> >-> I have a question about the feasibility of sharing data between two >->applications -- one Informix-based, and one Ingres-based. I'm not up on >->Ingres and SQL-compatibility, but I'd like to make it easier than having >->to do SQL unloads and loads on a periodic basis. Is there an easier (and >->more user-transparent) method? I'm interested in efficiency as much as >->I am in seamless-appearing integration. > >One possibility: > >Write a program in C to run in your crontab. The program should: >1. Connect to one database. >2. Select data into program arrays. ** >3. Disconnect from the database. >4. Connect to other database. >5. Insert saved data into appropriate tables. >6. Disconnect from the second database. >7. If there were any problems, mail a message to your DBA. >8. Quietly go away. > >** This assumes the data is of moderate size. If the data is truly huge, >then you might want to unload to file(s), and then load from file(s) in >step 5. > >Key points to this approach are: >1. Program runs automatically, via cron. >2. It requires embedded SQL/C products for both DBMSs. If you are suggesting building a single executable that will access both dbmss, they it also assumes that ASK and Informix do not have any functions in our libraries that have the same name. I would not bet the farm on this. From personal experience, having a single executable that will access two or more vendors databases does not work. You could, of course, have 2 executables that share data via shared memory, or message queues, or whatever. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney