Hi community, (and @Les Dover
I have a question for you regarding the mask value of DB2 cell with a fixed xml value.
This is the case:
- Fast Data Masker v.4.10.45.0
- DB2 Z/OS
- table with a column of type "XML NOT NULL"
I'm trying to mask this column with a fixed value "null"... so I thought that I have to insert this value "<?xml version="1.0" encoding="UTF-8"?><null/>"
in the FDM I choose the table, the column and ...
I've tried with:
- Fixed: inserting the xml in the test box "Fixed Value"
- Fixed: inserting the xml in the XML/JSON Data text box
- Fixed: inserting "//" in the XML/JSON Data text box
- SQLFUNCTION: inserting the xml in the text box
- SQLFUNCTION: inserting a select with the xml in the text box
both SQLFUNCTIONS are working if I use them directly as query on the DB.
Every test I did end with the same error:
2023-02-28 14:18:41.532 main - Validating table names, column names and data types for mapping file...
2023-02-28 14:18:41.540 main - starting validate:2023.02.28 14:18:41.540 CET
2023-02-28 14:18:41.541 main - Validating mapping row 1 of 1
2023-02-28 14:18:41.589 main - message not found Masking for function:FIXED for language:en()
2023-02-28 14:18:41.590 main - Masking of data type XML not supported for DB2
2023-02-28 14:18:41.591 main - exit value = 1
or
2023-02-28 16:51:45.209 main - Validating table names, column names and data types for mapping file...
2023-02-28 16:51:45.216 main - starting validate:2023.02.28 16:51:45.216 CET
2023-02-28 16:51:45.217 main - Validating mapping row 1 of 1
2023-02-28 16:51:45.263 main - message not found Masking for function:SQLFUNCTION for language:en()
2023-02-28 16:51:45.264 main - Masking of data type XML not supported for DB2
2023-02-28 16:51:45.264 main - exit value = 1
Could anyone help me on this?
Thanks in advance
Stefano