Re: Desperate Plea for Help

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. Sorry for the followup, email fails (see below). If you post more detailed info it would be easier to, for example, look for possible bugs in the bug database: the platform and port # (4.00.??-?); the command that fails; the numeric values from sqlca.sqlcode and sqlerrd[1], would all help. (The same details would of course be requested by the telephone support person, so think of this as practice...) > Glenn Chambers gchamber@nfsun.uucp > Intelligent Technology Group nfsun%gchamber@uunet.uu.net the first address produces this from our local mail gateway: ----- Transcript of session follows ----- bad system name: nfsun uux failed ( 68 ) 550 <gchamber@nfsun.UUCP>... Host unknown the second address yields this from uunet.uu.net: ----- Transcript of session follows ----- 920609124428.0643 uux: error -- Bad system name: gchamber 920609124428.0643 uux: ERROR -- code 68 550 <nfsun%gchamber>... Host unknown