Re: Connect support in 4GL??

>Date: Fri, 07 Jul 1995 10:02:52 -0700 >From: jvemo@cyberspace.com (Jon C. Vemo) >X-Informix-List-Id: <list.6838> > >I have a logging database and a non-logging database. I want to be able to >access data on one, from the other, with 4GL. Because of the differences in >logging, I seem to be forced into using the "connect" feature of OnLine 7.1. > >However according to TFM, the "connect" statement appears to only be >supported with the embedded language products, and dbaccess. Can anyone >confirm or deny, that the current version of 4GL (6.01) does not support >"connect"?? Will there be a version of 4GL that supports "connect"?? and when?? > >Jonathon, can you shed some light on this for me? Was I summonsed? If so, my name is not spelt thusly... There is no direct support for CONNECT, DISCONNECT or SET CONNECTION in version 6.0x I4GL, nor are there any plans for it to be supported. However, one of the components of the I4GL compilation system is the 6.0x ESQL/C compiler, and it does understand CONNECT et al, and therefore you can write I4GL-callable ESQL/C functions to handle the connections for you. You can compile these with the c4gl script and build them into a general purpose library and link them into programs as required. Note that the CONNECT, DISCONNECT and SET CONNECTION statements are not preparable, so the normal ruse of doing PREPARE and EXECUTE will not work. Also note that CONNECT et al were introduced in Version 6.00 and are therefore available in all later versions too. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>