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 is the syntax for seeing the columns and data types of a table in the db2 database?
Can you use max on a char column?
What is the syntax for FETCH in DB2 ?
What are the bind parameters ibm db2?
What is database reorganization?
What is a system catalog table in db2?
What is a db2 collection?
What is collection in db2 bind?
What is dbrm? What it contains? When it will be created?
What is the use of predicate?
What is page size in db2?
Mention data types used in db2 ?
What is dbrm? When it will be created?
What are concurrency issues?
What are db2 tables?