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 dbrm? When it will be created?
Explain db2.
How will you return the number of records in table?
What are the benefits of using the db2 database?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is an instance in db2?
What is the connection string to connect to the DB2 Database ?
Explain dclgen.
What is the difference between dbm cfg and db cfg file in db2 ?
What is cursor with hold option in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
can all users have the privilage to use the sql statement select * (dml)?
Explain how can you do the explain of a dynamic sql statement?
Explain about rct in db2?
What is node in db2?
