Example: Creating an Exclusion List Named ‘MyExclusions’ - Teradata Vantage

This example you creates an exclusion list named MyExclusions. MyExclusions consists of all tables in the Payroll database, 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);