Scd.Subjob Linked Table Filter

The Scd. Subjob Linked Table Filter table is used for setting filters on how the linked table is linked to the Scheduler Subjob.

When you set filters on linked tables, you select the fields to filter on in the Scd. Subjob Linked Table Filter table and select if the filter is either a constant, a field from the scheduler subjob or a specifically designed filter. When the subjob is replicated, the replication process replicates from the linked table, taking into account the filters set up for the linked table(s).

Example
To link the replication of Statement Line table to the Statement table, you set up a subjob for the Statement table and then link the Statement Line table to the Statement table subjob. For linking the statement lines to the relevant statement you select the Statement No. field in both tables as a link. Then, when a Statement record is replicated, all records in the Statement Line table that have the same Statement No. are replicated as well.