What is read-only cursor?



What is read-only cursor?..

Answer / 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

Post New Answer

More DB2 Interview Questions

What is an instance database?

0 Answers  


wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  


When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  


insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,


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

0 Answers   MCN Solutions,






What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  


suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,


What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  


What are the contents of dclgen?

0 Answers  


What is cloudant database?

0 Answers  


In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,


What is the clustering index in the db2 database?

0 Answers  


Categories