no...for that we are using cursors. due to cursors we can retrieve or fetch

Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?

Question Posted / satheesh reddi

Answer Posted / satheesh reddi

no...for that we are using cursors. due to cursors we can retrieve or fetch number of rows at a time from the table

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is copy pending status in db2?

1068

What is iseries database?

990

What is db2 stogroup?

1095

What are concurrency issues?

1029

What is sqlca’s maximum length?

1102

What is null indicator in cobol db2?

992

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1227

What is precompiler in db2?

958

What is package in db2 mainframe?

917

Define check constraint.

1025

What are packages in db2?

972

How to create db2 table in mainframe?

1103

What is node in db2?

986

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

2779

What is buffer pool in the db2 database?

1046