CURSOR with FOR READ ONLY

Susanta · Active User Joined: 17 Nov 2009 Posts: 126 Location: India

Hi

I have a query.
If a DB2 cursor is declared with "FOR read only" and commit is performed in between the process, will it close the cursor.

Thanks

Pandora-Box · Posted: Thu Nov 29, 2012 4:34 pm

Is this a Interview question and what happen when you tried?

sushanth bobby · Posted: Thu Nov 29, 2012 5:04 pm

Susanta,

Yes.

If the cursor is declared using WITH HOLD, it will not be closed during commit.

Thanks,
sushanth

Susanta · Active User Joined: 17 Nov 2009 Posts: 126 Location: India

HI all,

I have seen a program already running fine in production , Which uses "FOR read only" in the cursor declaration. It also performs COMMIT each time it finishes processing 10,000 rows . But cursor not getting closed by the COMMIT.

I used to know for declare cursors we need to mention "WITH HOLD" if we want to perform COMMIT in between . thats why i got above doubt.

Thanks

Susanta · Active User Joined: 17 Nov 2009 Posts: 126 Location: India

Apologies ..........

I dint observed earlier .. the declaration has "WITH HOLD" mentioned at the top.