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 db2 restart?
Give the name of some fields form sqlca.
What is the latest version of ibm db2?
What is meant by dclgen?
Are views updateable?
What is null indicator in db2?
Define sqlca.
How to rename a table in DB2 ?
Which are the db2 tools to protect integrity of the database?
How can deadlocks be resolved?
Can there be more than one cursor open for any program?
What is the use of dclgen in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the maximum No of rows per page?