Considerations and restrictions for the replication of XML data

CDC Replication can replicate data in XML columns available in your database. The following considerations and restrictions exist for the replication of XML data:

• XML data types are not supported in non-nullable columns on target tables.
• You cannot map XML columns in a source table to key columns in a target table.
• You cannot define XML columns as key columns in a target table.
• You cannot reference XML columns in derived or row-filtering expressions.
• XML columns are not supported for Conflict Detection and Resolution operations
• XML columns are not supported for value translations
• XML columns are not supported for code page translation
• XML type source derived columns are not supported
• Db2® for z/OS®: XML columns are not supported for code page overrides, but they will be translated, if required.
• Db2 for z/OS: XML data types are supported in nullable columns on target tables
• Db2 for z/OS: You cannot pass XML columns to user exits