Start of change

-4730   INVALID SPECIFICATION OF XML COLUMN table-name.column-name IS NOT DEFINED IN THE XML VERSIONING FORMAT, REASON reason-code

Explanation

The indicated column is not valid in the context specified. The column must be defined in the XML versioning format.

table-name
The name of the table.
column-name
The name of the column.
reason-code
The reason for the message or SQL code, indicated by one of the following values:
1
The target of the SET assignment clause containing the XMLMODIFY function invocation is a column that is not XML in the versioning format. The target of an assignment involving an invocation of the XMLMODIFY function must be an XML column that is in the XML versioning format.
2
A SELECT FROM UPDATE or SELECT FROM DELETE statement specified OLD TABLE, and referenced an XML column that is not defined in the XML versioning format.

System action

The statement cannot be processed.

User response

Correct the syntax, and reissue the statement.

1
Change the SET assignment clause to specify an XML column that is defined in the XML versioning format, or remove the XMLMODIFY function in the assignment clause.
2
Change the column specified in the SELECT FROM UPDATE or SELECT FROM DELETE statement to specify an XML column that is defined in the XML versioning format.

SQLSTATE

55079

End of change