Read-only cursor is a cursor that is defined with FOR FETCH ONLY clause.

What is read-only cursor?

Question Posted / s

Answer Posted / s

Read-only cursor is a cursor that is defined with FOR FETCH
ONLY clause. The curosor is defined with SELECT, SELECT
INTO.

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Mention the different locking levels that are available in db2.

1116

What is universal database?

1052

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1221

What is db2 bind process?

1221

How can the duplicate values be eliminated from db2 select?

1080

Define check constraint.

1062

What is runstats db2?

1003

What is check constraint. Explain with example.

1083

What are the various data types available in db2?

1074

What is phantom read in db2?

1133

What does db2 stand for?

994

Is ibm db2 open source?

1052

Which is faster delete or truncate?

1108

What is reorg and runstats in db2?

1203

What are db2 objects?

1032