Re: Using Esql/C and INformix4gl on other SQL database

On Mon, 31 Aug 1998 sseb2972@my-dejanews.com wrote: > Just a question, > Is it possible to use a program written in esql/c or Informix 4gl to access an > other database (sybase/oracle) ? > > Do You know if kind of "compiler" exist to convert an informix esql/c program > to other embedding SQLC language. In the ordinary course of events, the answer to both questions is No. One major problem area is the data types, especially Informix-specific ones such as DATE, DECIMAL, DATETIME, etc. You might be able to find gateway products which allow an Informix-ESQL/C application to connect to a non-Informix databases; there used to be gateway products for accessing DB2, for instance, though I'm not sure whether these are still current products. You might be able to use a non-Informix ESQL/C compiler on Informix ESQL/C code (and I4GL generates ESQL/C code), but it is unlikely to handle the Informix types and use the Informix headers so it is much more likely to be impossible than possible. Certainly, unless the program was explicitly written to be portable between ESQL/C compilers, I wouldn't expect it to work. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn