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 r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,


What is IMAGECOPY ?

6 Answers  


What is difference between isnull and coalesce?

0 Answers  






Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  


Can we install 2 different versions of Db2 on same mainframe?

3 Answers  


What is COPY PENDING status?

6 Answers  


what is a collection?

2 Answers  


can any one expalin check point with an example?

1 Answers  


how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


What are host variables in db2?

0 Answers  


Categories