RE: oracle/sql server with informix

Posted in 1998

Fernandes, Rudolf — Tue, 8 Dec 1998 14:44:00 -0500 — source: Informix-list mailing list archive (1991-1998)

Here's a quick and dirty (very dirty) way of handling it. Get your Oracle SP to fire off a script. The script's job would be to unload data to ascii into a pre-determined location. Following that, the Oracle SP would load the ascii file. Rudy -----Original Message----- From: "Sandra Ward" [SMTP:sandraw@peregrine.ie] Sent: December 9, 1998 8:54 AM To: "'informix-list@iiug.org'" [SMTP:informix-list@iiug.org] Subject: oracle/sql server with informix I have a question that I need some guidance on. I need a Oracle/SQL server stored procedure to be able to access data from an Informix table somehow. We have oracle running on NT here and we hope to interface with another system sitting on informix, however we need to pull the info. from informix tables. I need some guidance immediately. Can you help me or even point me in the right direction. Thanks Sandra