Start of change

-20517   XMLMODIFY ATTEMPTED TO UPDATE A COLUMN WHICH WAS NOT SPECIFIED IN THE UPDATE SET CLAUSE

Explanation

The XQuery updating expression in the XMLMODIFY function invocation attempted to update XML nodes that are not part of the column that is the target of the SET assignment clause that contains the XMLMODIFY function invocation. The XMLMODIFY function can update XML nodes in the target column only.

System action

The statement cannot be processed.

Programmer response

Change the XQuery updating expression in the XMLMODIFY function to only refer to XML nodes that are part of the column that is a target of the assignment.

SQLSTATE

428I1

End of change