MCQs>IT & Programming>DB2 Programming>Given the following cursor declaration: DECLARE CLASSUPDATE CURSOR FOR SELECT CSTITLE FROM T001.CLASSS FOR UPDATE OF CDUR Which of the following embedded SQL statements will use this cursor correctly?
DB2 Programming MCQs
Given the following cursor declaration: DECLARE CLASSUPDATE CURSOR FOR SELECT CSTITLE FROM T001.CLASSS FOR UPDATE OF CDUR Which of the following embedded SQL statements will use this cursor correctly?
Answer
Correct Answer: UPDATE T001.CLASSS SET CDUR = 5 WHERE CURRENT OF CLASSUPDATE
Explanation:
Note: This Question is unanswered, help us to find answer for this one