Re: Desperate Plea for Help

I tried to email, but "nfsun" doesn't seem to be well-known... In article <814@nfsun.UUCP> gchamber@nfsun.UUCP (Glenn Chambers) writes: >I have an application using dynamic SQL in C, that worked just fine >until I had to add "WITH HOLD" to the DECLARE CURSOR statements (because >of the sudden need to occasionally have a transaction inside a multiply >nested SELECT-FETCH loop.) > >Unfortunately, adding "WITH HOLD" causes certain complex nested selects >(that don't have any transactions inside them) to blow up with the dreaded >"Can't read sorted rows, file not open" error. i.e. error -565. What was the related ISAM error number? If -101, it could be known bug 9246 (fixed in 4.10.UD2 engines), but that's not normally related to using WITH HOLD. >Has anything resembling this happened to anyone else? Did Informix have >a solution for you, or did you have to look for your own solution? If the >latter, did you find one? There's a known fix for bug 9246, and it's available on most platforms by now, but it would mean migrating to 4.1 engines if you haven't already. >Glenn Chambers gchamber@nfsun.uucp >Intelligent Technology Group nfsun%gchamber@uunet.uu.net >Pittsburgh, PA -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "Men without women are like fish without water to swim in With their eyes bugging out, they flop on the beach And look up at the girls who are just out of reach." Was (not Was) "Shadow and Jimmy" David Was/ Elvis Costello