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?
Answer Posted / 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 |
Post New Answer View All Answers
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is dclgen (declaration generator)?
How do I add a column to a table in db2?
Which isolation level provides maximum concurrency?
What is precompiler in db2?
What is the use of reorg in db2?
What is the function of logging in the db2 database?
What is cobol db2?
How will you return the number of records in table?
How do you pull up a query which was previously saved in qmf?
How do I import a csv file into db2?
Explain the contention situations caused by locks?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Define db2.
What db2 400?