In the following, Saturday and Sunday of each week of the Teradata business calendar are defined as non-working days (non-working days have the OFF status) and this information is added to the DBC.BusinessCalendarPattern table.
By default, each day of week for the Teradata business calendar is a working day.
EXEC DBC.CreateBusinessCalendarPattern
('TERADATA', ‘SATURDAY’,’OFF’, ‘Non-work Day’);
EXEC DBC.CreateBusinessCalendarPattern
('TERADATA', ‘SUNDAY’,’OFF’, ‘Non-work Day’);