Re: What's the disadvantage of WITH HOLD cursor?

"Carl Y. Wu" wrote: > > A cursor will be closed by COMMIT WORK unless you declare it "WITH HOLD". > What's the real advantage of this default behaviour? > Is there any problem if I declare all cursors "WITH HOLD" to avoid this > default behaviour? Why would you want to? This is only really useful for scrolling cursors. If you require multiple scroll cursors open simultaneously, then I'd be suspicious of your SQL. ;-) That's not to say you haven't found a requirement, but keeping open cursors to a minimum saves on resources. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+