To exclude tables or join indexes from the list to analyze and reassign to different maps, use procedures to create an empty list of exclusions and then add objects to it. In the following example, a DBA creates an exclusion list named MyExclusion, consisting of all tables in database Payroll, an individual table Employee.Withholding, and all tables in database Taxes whose names begin with Rate.
CALL TDMaps.CreateExclusionListSP('MyExclusions', NULL, :ExclusionListId);
CALL TDMaps.AddExclusionListEntrySP('MyExclusions', 'Payroll', NULL,:NumObjectsAdded);
CALL TDMaps.AddExclusionListEntrySP('MyExclusions', 'Employee', 'Withholding',:NumObjectsAdded);
CALL TDMaps.AddExclusionListEntrySP('MyExclusions', 'Taxes', 'Rate%', :NumObjectsAdded);
The result is that these tables are marked as exclude in the ActionsTbl and are not considered for redistribution to other AMPs. The list of excluded objects is visible in the view TDMaps.ExclusionLists[V][X].