Increase the max number of cursors allowed

Posted in 1998

Lee Wan Ling — Tue, 03 Mar 1998 16:16:19 +0700 — source: Informix-list mailing list archive (1991-1998)

Hi there, I'm using CLI2.5 on OnLine 7.23 and I'm trying do write a big transaction with cursors. Half way through the transaction, it tells me that I've run out of cursors after 254 rounds of update. I've set the Statement Option for SQL_CONCURRENCY to SQL_CONCUR_LCK. Is there any way I can increase the maximum num of cursors allowed or should I set my CONCURRENCY mode to something else? Regards, Wan-Ling