Row-level filtering in Data Virtualization

You can apply filter criteria to include or exclude rows from virtualized data in Data Virtualization, to restrict the data that users can view.

Access to the tables that are referenced in the row-level filter expressions is not evaluated, including data masking.

Row filtering rules that apply to Data Virtualization assets and reference other assets must reference Data Virtualization assets only. If you query an object and the row filtering rules reference assets that are not Data Virtualization assets, the query fails with the following error:

The statement failed because a Big SQL component encountered an  error. Component
      receiving the error: "SCHEDULER". Component returning  the error: "SCHEDULER". Log entry
      identifier:  "[SCL-0-<log_entry_id>]".. SQLCODE=-5105, SQLSTATE=58040

You can confirm the cause of the error by running the following query:

select line from table(syshadoop.log_entry('SCL-0-<log_entry_id_from_error>'))

For more information about this data protection rule, see Filtering rows in data protection rules in the IBM Knowledge Catalog documentation.