"Sean McKeough" <mckeough@nospam.ca.ibm.com> wrote in message
news:bqo1l4$1e6$1@hanover.torolab.ibm.com...
> A result set is part of the calling statements unit of work. Rollback
> will always close all cursors for the application (including result sets).
>
I don't know about "result sets" but a declared cursor can be held open past
the commit/rollback using the WITH HOLD option.