Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?



Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the adv..

Answer / hitendra valluri

As per my knowledge if we loop the select query it retrieves the same data untill we explicitly handle the where clause to retrieve the rows. Unlike select CURSOR fetches all the rows and allows the program to process 1 at a time.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What are the uses of db2 optimizer?

0 Answers  


When is the skeleton cursor table created?

1 Answers  


Name the lockable units in DB2?

0 Answers  


what is difference between random and sequence file access

1 Answers   Syntel,


When do you specify the isolation level?

0 Answers  


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  


What is deadlock?

2 Answers  


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,


What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,


Update command

1 Answers  


Categories