how to fetch multiple records without using cursor
Answer Posted / premil
It can be done with the help of dynamic sql queries
(prepare,execute).
but i dont remember the syntax...
sorry ...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is meant by explain?
What are the prerogatives?
How to rename a table in DB2 ?
How would you find out the total number of rows in a db2 table?
Mention the definition of cobol in varchar field.
What are the various isolation levels possible?
What is view db2?
How do I create a view in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is drop table?
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
How do I add a column to an existing table in db2?
How to restart a DB2 program?
Which isolation level provides highest data integrity?