how to fetch multiple records without using cursor
Answer Posted / rajni
U cant fatch the record without using cursor.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Comment whether the cursor is closed during commit or not.
What's The Percentage Free Space ?
How to take backup of table in db2?
What is node in db2?
What is the use of predicate?
How to fetch the last row from the table in SQL (db2)?
How to check table size in db2 sap?
How to rename a table in DB2 ?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Are view updateable?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is a page in db2?
What is the meaning concurrency in the db2 database?
What is the maximum length of sqlca?