-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