What is a cursor and what is its function?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we retrieve the total number of records in RPG & CLLE?

194


Explain in brief how does db2 determine what lock-size to use?

589


What is check constraint in db2?

603


List out the three types of page locks that can be held.

685


How to view db2 table structure?

587






What is dbrm? When it will be created?

594


How can record locking be achieved in those DB2 versions which do not support it?

623


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

628


What is db2 stogroup?

673


Discuss about db2 bind?

667


Why do chiropractors use drop table?

656


What is the difference between db2 and oracle?

671


Can you tell me how can you find out the # of rows updated after an update statement?

608


What is the difference between plan and package in db2?

568


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

698