what is the difference between normal select query and
currosor
- 2 Answers
- 16351 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / jagan
using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.
In case more than one row is retrieved in a select clause it
will throw -811 sql error.
| Is This Answer Correct ? | 28 Yes | 5 No |
Post New Answer View All Answers
What's The Percentage Free Space ?
Is the primary key a clustered index?
Explain correlated sub-queries.
Explain various types of locks in db2?
What is db2 look?
What is db2?
What is db2 plan table?
What is package in db2 mainframe?
Discuss about db2 bind?
What is commit in db2?
What is the use of db2 optimizer?
Explain about rct in db2?
What is collection in db2 bind?
How can record locking be achieved in those DB2 versions which do not support it?
How to retrieve rows from a db2 table in embedded sql?
