how to fetch multiple records without using cursor
Answer Posted / anto
The question is to fetch multiple records...not multiple
row(s)..
So this is possible with single select query.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why do we bind in db2?
Define check constraint.
What are concurrency issues?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the difference between cursor and select statement?
How is deadlock resolved?
What is the physical storage length of date data type?
What is dbrm?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is image copy in db2?
When the like statement is used?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
If I have a view which is a join of two or more tables, can this view be updateable?
What are the different types of base tables?