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?
- 2 Answers
- 5609 Views
- Deloitte, I also Faced
- E-Mail Answers
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
What is db2 optimizer?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is difference between isnull and coalesce?
How do we specify index to include or not during bind process.
What is data manager?
Give a brief description of db2 isolation levels?
What is release/acquire in bind?
What is phantom read in db2?
What is universal database?
How can we retrieve the total number of records in RPG & CLLE?
What is buffer pool?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Mention the definition of cobol in varchar field.
How do I delete a table in database?
