Re: Last Gasp

Posted in 1993

Richard Ridley — Tue, 23 Mar 93 15:59:38 +0800 — source: Informix-list mailing list archive (1991-1998)

%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT Re: Last Gasp %VERIFY y %DATE 23/03/93 15:59 %REFERENCE 16628 Johnathan Leffler writes: |It may not be want you wanted to hear, but I tested your code on a |Sun running SunOS 4.1.3 with OnLine 5.01.UC1A2, I4GL-RDS 4.10.UC1 |and I4GL-ID 4.10.UC1. I don't have a running OnLine 4.10 system at |hand. |The two databases I used were part of the same OnLine system because |your example did not show any need for I-Star -- your remote table |would have to be referred to as other_db@other_site:table to need |I-Star. That's fine - the reason I-Star is on the machine is because of other implementations, however you will need to test this with I-Star installed, as the sqlturbo executable will be different (see below combinations that I tested). |Once I'd chosen two databases with the same logging mode, and |corrected the code (which uses temp1_exists but declares |tab1_exists), the program worked correctly first time. Oops - so much more simplifying the variable names (it's the thought that counts tho' :)) |Since your message suggests I-Star is the cause of the trouble, |would you care to re-frame your problem in terms of what you are |really suffering from, or is it that the Version 5 engine doesn't |suffer from the problem? If you revise your example, I suggest you |use column tabname from table systables (and perhaps colname from |syscolumns for the second query), so the only change I have to make |is to the names of the databases I use, and the system name if |necessary. To re-frame : Yes, as far as I know (and can test with the limited number of 5.0 I-Star's available to me, namely one), the problem does not occur with 5.0 I-Star: Online 4.10.UE4 No Informix-Star : Works OK Online 4.10.UE4 Informix-Star 4.10.UE4 : Gives the error Online 4.10.UE4 Informix-Star 4.10.UE5 : Works OK Online 4.10.UG1 Informix-Star 4.10.UG1 : Gives the error Online 5.00.UC2 No Informix-Star : Works OK Online 5.00.UC2 Informix-Star 5.00.UC2 : Works OK Regards, Richard Ridley %UEND