What is a cursor and what is its function?

Question Posted / guest

Answers were Sorted based on User's Feedback

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

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

More DB2 Interview Questions

What are the functions of Bind?

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

What is sqlcode -811?

How to find schema of a table in db2?

What is node in db2?

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

What are common abends

What is the syntax for seeing the columns and data types of a table in the db2 database?

Which catalog table stores referential constraints?

What information can you find in SYSIBM.SYSLINKS table?

Which one allows duplicate values Union or Union All ?

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

For more DB2 Interview Questions Click Here