Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal select query and
currosor
- 2 Answers
- 17592 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 is a dbrm in db2?
What is a db2 package?
What's The Percentage Free Space ?
Explain dclgen.
Explain packages.
What is package in cobol db2?
What is the use of reorg in db2?
Explain about dbrm.
What is the difference between using bind () and rebind () methods of naming class?
What is the result of open cursor statement?
What does runstats do in db2?
How do I start db2 in windows?
On which levels locks can be applied?
What are the benefits of using the db2 database?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
