how to fetch multiple records without using cursor
- 14 Answers
- 35010 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rookie
#6
I think that answer #6 is definately a food for thought.
Logically speaking that's definately possible, but can
anyone verify it practically:-)
I think it should work....nothing wrong in logic.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define buffer pool.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How do I copy a table in db2?
What is role in db2?
What is the reason behind not using select * in embedded sql programs?
What do you mean by rollback?
How can you do the explain of a dynamic sql statement?
What is db2? Explain.
Is db2 free?
What is universal database?
Mention data types used in db2 ?
What is bind plan?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Can there be more than one cursor open for any program?
Which is faster delete or truncate?
