Delphix Products

 View Only
Expand all | Collapse all

Delphix Masking - Parametrization of list - On the Fly Masking

  • 1.  Delphix Masking - Parametrization of list - On the Fly Masking

    Posted 02-03-2021 12:53:00 AM
    Hi All,

    While trying to pass a list of comma separated values as a List in the Rule Set, the auto generated query fails because the 'where' clause it is missing the table schema.
    Has anyone encountered this problem and is there a way to override this?

    I am working with a DB2 zOS table with a IBM JDBC driver on Delphix masking engine 6.0.5.

    ------------------------------
    Satyadarshi Mohanty
    Delphix Community Members
    ------------------------------


  • 2.  RE: Delphix Masking - Parametrization of list - On the Fly Masking

    Posted 02-04-2021 02:36:00 AM
    Hello,
    why not try to add in where clause the schema ?

    where_clause:
    schema.column1 ="123"

    depending on JDBC driver have seen sometimes that they require the value as:
    "schema"."column1" = "123"

    As far as I remember that was the case for DB2 zOS.

    Regards