what is the difference between normal select query and
currosor
- 2 Answers
- 16326 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 are stage one indexable predicates?
What is bind plan?
What is Skeleton cursor table (SKCT)?
What is a clustering index?
What is a system catalog table in db2?
What is COPY PENDING status?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I add a column to an existing table in db2?
What is the self-referencing constraint?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
Can one database have multiple instances?
What is the difference between nvl and coalesce?
COBOL 
