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 the picture clause of null indicator variable?
What is a plan and package in db2?
What is explain plan in db2?
How to retrieve rows from a db2 table in embedded sql?
What is data manager?
What language is db2 written in?
What is db2 purescale?
What is a db2 collection?
How to restart a DB2 program?
What is dclgen in db2?
What are the uses of db2 optimizer?
What is copy pending status in db2?
What is declare cursor?
What is load replace in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.