Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / yaswanth
we will use cursors when we have situation like the query
returning multiple rows but in this case
select Count(*) from EMP table where EMPNAME='some' will
return only one row, i.e how many rows it found with
EMPNAME='some' eg:3 or 4 or 5 ... so there is no concept of
cursor here
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is reorg and runstats in db2?
When reorg is used?
What happens in bind step in a db2 program?
What is sqlca’s maximum length?
What is package in cobol db2?
What is buffer pool?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is rebind in db2?
What is ibm db2 database?
What do you mean by cursor?
What is a db2 tablespace?
What is explain in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How does coalesce work?
Where do you specify them?
