DeleteException Macro | VantageCloud Lake - DeleteException - Teradata VantageCloud Lake

You can use this macro to delete an exception from a specific business calendar. When you delete an exception, the status for that exception day reverts to its defined status in the pattern for the calendar.

When you run the macro, the exception is removed from the calendar and from the DBC.BusinessCalendarException table.

If you need to delete all of the exceptions from a calendar, use the DeleteAllExceptions macro (see DeleteAllExceptions).