what is the difference between normal select query and
currosor
- 2 Answers
- 16290 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 |
What is a cursor and what is its function?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is the database descriptor?
What are packages in db2?
What is meant by explain?
Which transaction use a command thread ?
What is role in db2?
What db2 400?
What is the function of logging in the db2 database?
Can you Average the Characters ?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
COBOL 
