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

What are packages in db2?

1019

What is bufferpool in db2?

1049

What is node in db2?

1042

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2840

List down the data types in the db2 database.

1115

What are concurrency issues?

1094

What is difference between rollback and commit?

1154

How do you concatenate the firstname and lastname from emp table to give a complete name?

1073

How to create db2 table in mainframe?

1154

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1055

Define sqlca.

1104

What is the connection string to connect to the DB2 Database ?

1123

What is temporal table in db2?

1035

How to connect to db2 database from windows command line?

1061

Explain how can you do the explain of a dynamic sql statement?

1119