Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vinod babu bachina
In DB2 cursor is used to fetch more than one row from a DB2
table. But cursor can fetch only one row at a time. Suppose
if ur retrieving more than one row from table , u have to
use cursor only. If u use SELECT instead of cursor then it
leads to error '' more than one row selected in select'.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the two types of logging in the db2 database? Explain them.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is collection in db2 bind?
What are the full forms of spufi and dclgen and why are they used?
How to retrieve rows from a db2 table in embedded sql?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is bind plan?
What is iseries database?
When the like statement is used?
Are views updateable?
What does runstats do in db2?
is it compulsory commitment control in journal?
What are the uses of db2 optimizer?
How to compare data between two tables in db2?
