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

How do you stop a db2 database in linux?

968

How to find schema of a table in db2?

966

How do I start db2 in windows?

1035

What is package in cobol db2?

1086

How does a cursor work?

933

What is meant by dclgen?

1071

What is plan in cobol db2?

1072

How is a typical db2 batch pgm executed?

1122

Why do we use cursor?

1056

what is diffrence b/w file-aid tool and file-aid utility???

4827

What is the use of runstats in db2?

1039

Explain dclgen.

1152

Is db2 a database?

923

Define declaration generator (dclgen).

1072

Define buffer pool.

1005