Hi , I am posting some interview ques .

what is the use of cursors ? what is the diff between
select and cursor ? bith are used for data retrival ..
rite?




Answers were Sorted based on User's Feedback



Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between s..

Answer / yuvaevergreen

>>Cursors are memory structures used to handle multiple
rows at a time.
>>Though,select statement can fetch only multiple rows, we
cannot handle multiple rows using host variables.
Basic difference would be single row handling and multiple
rows handling.

Is This Answer Correct ?    6 Yes 0 No

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between s..

Answer / reddy

cursors are used to retrieve multiple rows . Cussors will
retrieve one row at a time and save the data in the
hostvariables.For retreiving the 2 nd row, we need to
repeat the loop.the same process is continued at the end of
data.

select stmt will retrieve multiple rows at a time. assume
that there are 10 rows in a table.
EX: EXEC SQL
SELECT empno , ename into :hvempno ,:hvename from emp;
END EXEC;

Here the above sql query reults all the 10 rows. But , the
host variables will hold only one row of data.the remaining
9 rows will not be stored any where.

hope this may help u

Is This Answer Correct ?    4 Yes 4 No

Post New Answer




More DB2 Interview Questions

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

2 Answers   Verizon,


List down the data types in the db2 database.

0 Answers  


How do we specify index to include or not during bind process.

0 Answers   Satyam,


Explain an outer join?

1 Answers  


What are the benefits of using the db2 database?

0 Answers  






What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   TCS, CTS, IBM,


What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  


How can you display the current date & current time ?

1 Answers   Cap Gemini,


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


Highlight all the advantages that are attached to a package.

0 Answers  


What is a predicate?

1 Answers  


What happens to the PLAN if index used by it is dropped?

1 Answers  






Categories