Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal select query and
currosor
- 2 Answers
- 17481 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vinay srivastava
Normal select Query fetches all rows in one go while cursor
fetches one row at a time.
| Is This Answer Correct ? | 10 Yes | 17 No |
Can you tell me how can you find out the # of rows updated after an update statement?
Compare a subselect to a join?
Explain in detail about buffer manager and its functionalities?
What is meant by dclgen?
What os does db2 run on?
wht r the requirements for writing a cobol-db2 pgm ?
How can you quickly find out the number of rows updated after an update statement?
What is ibm db2 database?
What is the STOSPACE Utility used for?
what is the maximum number of tables that can be joined ?
What is db2?
can we drop column from a table
COBOL 
