I have the following query related to positioned update/delete using cursor.
As per my understanding , for performing a positioned update using cursor (in a cobol-db2 program)
-- While declaring the cursor , the "FOR UPDATE OF" clause need to be used
-- Later while updating the specific row , "WHERE CURRENT OF cursor name" need to be used
My query is
-- In case of positioned delete , do we need to give "FOR DELETE OF" similar to the above case?
-- Actually , the program code ( a notepad version) which I am having with me has a positioned delete
but it is making use of "FOR UPDATE OF" itself in cursor definition
-- So does this mean that "FOR UPDATE OF" is commonly used for both positioned update/delete?
Thanks in advance