v8 Dynamic Scrollable Cursors

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

david.joyce@pstechnology.com - 08 Feb 2005 17:35 GMT

I am aware that v7 Static Scrollable Cursors do not work with
pseudo-conversational CICS because of the temp work file being
destroyed but will v8 Dynamic Scrollable Cursors work with
pseudo-conversational CICS due to these cursors directly using the base
table?

Reply to this Message

Fan Ruo Xin - 09 Feb 2005 03:03 GMT

I am not sure. But I don't think db2 dynamic scrollable cursors direct using
the base table. Either dynamic or static cursor, they both work on the copy
(in memory) of the physical table. One will lock the base table during the
update, another one will not.

> I am aware that v7 Static Scrollable Cursors do not work with
> pseudo-conversational CICS because of the temp work file being
> destroyed but will v8 Dynamic Scrollable Cursors work with
> pseudo-conversational CICS due to these cursors directly using the base
> table?

Reply to this Message