Re: SQL error -408

In article <5BE42DD4594F7A31.A76000D0F13E8278.589B089439FDDEA5@library-proxy.airnews.net>, Daniel Wright <danwright@bigfoot.com.REMOVE> wrote: >finderr reads something like this: >"Invalid message received from sqlexec" >Version 5.?? on AIX ?? >This happened in a 4GL, but when the query was ported to ISQL, it gave >the same result. > >Taking the order by away alleviated the error, (but was not >acceptable); changing the join to an OUTER, worked and was mildly >acceptable. > >I can show you the query if you think it makes a difference, but trust >me there is nothing wrong with it. In fact, without the ORDER BY, it >returns the same number of rows regardless of whether or not there is >OUTER join or not. > >Is this a known Informix bug? (My only possible conclusion), or is there >another explanation. > This error code occurs when the back-end sqlexec process associated with your program aborts. Your query caused sqlexec to abort. Contact Informix support, give them the query, and see if the problem is a known one.