INZU654E ALL THE XML DATA TYPE COLUMNS MUST BE SERIALIZED

Explanation

When processing a table having several XML data type columns, Optim™ High Performance Unload cannot process the corresponding values differently. Either the values of all these columns must be written into separate files, or they must be serialized. An SQL statement has been submitted with at least one explicit XMLSERIALIZE() scalar expression into it. But at least another XML data type column involved within this same SQL statement is not specified for being serialized, because either it has been specified without the XMLSERIALIZE() scalar function applied to it, or there is no XMLSERIALIZE clause applying to this SQL statement.

User response

Either disable any XML data serialization processing from the SQL statement concerned, by removing from it any specification of the XMLSERIALIZE() scalar function. Or enable the XML data serialization processing to all the XML data type columns: this can be done either by applying an XMLSERIALIZE() scalar function to all the XML columns involved in the SQL statement, or by adding a XMLSERIALIZE clause appropriately specified to target all the XML columns not yet being subject of the XML serialization processing.