Cursor is used by DB2 to fetch qualified rows one row at a time to the ap

What is a cursor and what is its function?

Question Posted / s

Answer Posted / s

Cursor is used by DB2 to fetch qualified rows one row at a
time to the application program.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What os does db2 run on?

769

Give a brief description of db2 isolation levels?

811

What is the difference between dbm cfg and db cfg file in db2 ?

1292

What is sqlca?

831

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

825

Define sqlca.

869

How can the duplicate values be eliminated from db2 select?

885

What is with ur in db2?

1050

What are the two types of logging in the db2 database? Explain them.

821

What is clone table?

814

What are the benefits of using the db2 database?

908

Which component is used to execute the sql statements?

862

What is the difference between bind and rebind in db2?

1205

What is the difference between nvl and coalesce?

840

Mention the location where the output received from explain statement is stored.

881