Re: Cursor starting over ESQLC w/ POSIX Threads

"Bryan Castillo" <rook_5150@yahoo.com> wrote in message news:1bff1830.0305131706.7160a8df@posting.google.com... > > select distinct aba, nacct from ckdelta where ckdeltaid >= 0> > I have 10342 unique items that should be returned by the cursor. > > For some reason on my 10343 fetch I get an item returned that was > already fetched from the cursor. I am not reopening the cursor. In > fact the cursor never stops fetching values (Until I send SIGINT). > I've gone through my logic a dozen times, I've checked the options to > the compiler and linker and they seem fine. I also tried setting the > cursor to be declared WITH HOLD. I'm at a complete loss. > > Are there some issues with threads and ESQLC I am missing? > Try select unique? > > thanks------- > > > [Info on my environment] > > (sample for compiling one object file) > env THREADLIB=POSIX esql -c -thread > -I/informix/distr/infx.9.21.UC3/incl > -I/informix/distr/infx.9.21.UC3/incl/esql -xCC -g -o ScoreThread.o > ScoreThread.ec > > > (sample for linking) > env THREADLIB=POSIX esql -thread -I/informix/distr/infx.9.21.UC3/incl > -I/informix/distr/infx.9.21.UC3/incl/esql -xCC -g -mt -o > p_rescore_ckdelta.exe DatabaseFunctions.o Logger.o MicrProducerSql.o > MicrWorkQueue.o MicrWorkSet.o ScoreController.o ScoreListenerConsole.o > SystemFunctions.o rescore_ckdelta_main.o DatabaseFunctions.o > MicrProducerSql.o ScoreThread.o > > > Informix Dynamic Server 2000 Version 9.21.UC3X1 -- On-Line -- Up 18 > days 10:27:02 -- 69632 Kbytes > > SunOS jabba 5.7 Generic_106541-22 sun4u sparc SUNW,Ultra-4