Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7342 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How do I change the column size in db2?
How can you count the number of rows from a table tab?
Explain various types of locks in db2?
What is a trigger in the db2 database?
Define data page.
What does a deadlock mean in DB2?
Can one database have multiple instances?
Outputs of explain are with matchcols = 0. What does this signify?
What is the role of schema in the db2 database?
How do I connect my db2 database to ibm?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How many databases can be created inside an instance in db2 ?
What is nvl in db2?
What is the use of db2?
What is declare cursor?
