I have a db2 zOs table that has XML field. I need to mask this xml column. I'm importing this table into PC through PowerExchange. Once the table is imported then, I'm not able to see the xml field in my meta data. Is there a way to read xml field in PowerCenter. TIA.
PowerExchange for DB2 z/OS does not support XML datatype columns.
This is doc'd in the topic "Datatypes Supported for DB2 for z/OS Bulk Data Movement" in the DB2 z/OS chapter of the PWX Bulk Data Movement Guide.
You would need to find some other solution than PWX for DB2 z/OS.