v8 Dynamic Scrollable Cursors

david.joyce@pstechnology. · *nix forums beginner Joined: 08 Feb 2005 Posts: 2

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?

Fan Ruo Xin · *nix forums beginner Joined: 13 Apr 2005 Posts: 42

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.

<david.joyce@pstechnology.com> wrote in message
news:1107884158.784108.266330@l41g2000cwc.googlegroups.com...

Google