What is a cursor?

Answer Posted / guest

A cursor is a programming device that is used to handle the
rows that are returned by the query as the host language
(cobol) can handle only one row at a time. its also a small
file that has the result set. The cursor has to be
declared,opened, fetched and closed to access the data
returnee by the query.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database alias db2?

606


What is the usage of open cursor command?

599


What is a db2 cursor?

626


What is db2 bind process?

757


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630






How can you classify the locks in db2?

636


What is page size in db2?

563


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

597


How do I add a column to a table in db2?

618


What are the prerogatives?

615


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7512


How is a typical db2 batch pgm executed?

642


Explain about rct.

652


What is the difference between oracle and db2?

587


What is null value in db2?

567