How can we declare a cursor for deleting row using cursor

mastrahoyar · New User Joined: 03 Mar 2007 Posts: 8 Location: hyd

I want to delete some rows by using cursor.

Please let me know the syntax to declare a cursor for deleting a row..

For update any column we declare cursor as "Declare c1 cursor for select * from table where condition
for update of column-name"

Can we use same syntax "for delete of column-name" for deleting rows by cursor.

dbzTHEdinosauer · Posted: Fri Oct 10, 2008 4:21 pm Post subject:

i believe the syntax is still for update of column-name.

I have always listed all the columns. don't know if it is required, but when someone else looks at the cursor declaration it is obvious something is going to happen to the complete row.

you could also check the db2 manuals - for a complete definition and description of the declare cursor statement in regard to issuing delete where current cursor.

arcvns · Posted: Fri Oct 10, 2008 4:35 pm Post subject:

Dick,

I believe it's not mandatory to have the 'FOR UPDATE OF' to do a positioned DELETE.