What is a cursor and what is its function?

Answers were Sorted based on User's Feedback



What is a cursor and what is its function?..

Answer / 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

What is a cursor and what is its function?..

Answer / harsha

cursor is used to retrive multiple rows.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,


Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  


What is dclgen (declaration generator)?

0 Answers  


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


What is a result table?

1 Answers  






What is dclgen in db2?

0 Answers  


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


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?

4 Answers   Mphasis,


When Can you be sure that a query will return only one row?

4 Answers   IBM,


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,


What is the difference between cursor and select statement?

0 Answers  


Categories