problem with informix cursor

Posted in 2003

ephesus — Fri, 16 May 2003 21:48:49 +0800 — source: Usenet: comp.databases.informix

i found informix sometimes may miss some records in fectch cursor,could someone tell me why? thx

↪ replying to ephesus

rkusenet — Fri, 16 May 2003 10:24:45 -0400 — source: Usenet: comp.databases.informix

"ephesus" <cainnn@netease.com> wrote in message news:ba2q8d$c2t$1@mail.cn99.com... > i found informix sometimes may miss some records in fectch cursor,could > someone tell > me why? > thx You need to tell :- a. what isolation level it has been set to. b. what is the logging mode of the database. c. whether the query was called within the transaction. Also, when did you notice the 'miss'. The first time query ran, or when re-running it.