can we update the table by using cursors can anyone post
the query?
Answer Posted / siri
suppose we want update ename in emp table using cursor....
declare crsorname cursor for
select * from emp
where dept='d005'
for update of ename....
upate emp
set ename=:ename
where current of cursor
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I add a column to a table in db2?
What are the contents of dclgen?
What is the use of dclgen in db2?
How to connect to db2 database from windows command line?
Why cursor is used in db2?
List out the buffer pools in db2
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is plan in cobol db2?
How to restart a DB2 program?
How do I import a csv file into db2?
Are views updateable?
What is the maximum number of columns in a db2 table?
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.
What is phantom read in db2?
How many databases are there?