What is a data filter?

A data filter is a parameter-value pair specifying a table column and its value. The filter specifies which rows of a table will be included in the synchronization request. The column and its value substitute into the WHERE clause of the SELECT statement of the subscription that the group uses. You enter this WHERE clause when you create the subscription (see Creating a DataPropagator subscription for more information). The WHERE clause is submitted to the source database during synchronization so that the DB2 Everyplace Sync Server returns only the subset of data required by a given group. More than one data filter can be applied for a specific user or group.

Související koncepce

Související úlohy