What is the significance of the CURSOR WITH HOLD clause in a cursor declaratio

What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?

Question Posted / guest

4 Answers
30370 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?..

Answer / abhisek

As soon as the COMMIT statement is executed in a
program,the cursor gets automatically closed,So we need to
give CURSOR WITH HOLD clause,in order to keep it open after
execution of the COMMIT statement.

Is This Answer Correct ?

43 Yes

2 No

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?..

Answer / ss

To remain cursor open after commit statement execution

Is This Answer Correct ?

33 Yes

0 No

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?..

Answer / yogendra shinde

Hi,
CURSOR with WITHOLD is very useful where we need to use
more than 1 database simultaneously.
Suppose you are reading or fetching a value from local
database and updating those retrieved values in a remote
DB. In such case when you connect to remote DB, you need to
use WITHOLD for local db. So that you don't loose the
cursor position for local db.

For further ref. do read more about CONNECT.

Is This Answer Correct ?

10 Yes

2 No

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?..

Answer / mainframe virumbi

The answers given above is correct only. Adding those, we
cant execute sql statements other than select, after commit
is encountered.

Is This Answer Correct ?

8 Yes

1 No

Post New Answer