If the view was redefined to the Sys_Calendar.CALENDAR_TD1310 view definition and you want to use the current version, you need to redefine Sys_Calendar.CALENDAR so that is has the definition of the current version. The current version (named Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE), is an internal view and has restricted access.
The current version can be used with the Teradata, ISO, and COMPATIBLE session calendars.
To redefine Sys_Calendar.CALENDAR from the Sys_Calendar.CALENDAR_TD1310 definition, replace the Sys_Calendar.CALENDAR definition with the definition of Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE:
- Use this statement to view the definition of the current view:
SHOW VIEW Sys_Calendar.Calendar_TD_ISO_COMPATIBLE;
- Use REPLACE to replace the definition of Sys_Calendar.CALENDAR with the definition of Sys_Calendar.Calendar_TD_ISO_COMPATIBLE.
The redefined Sys_Calendar.CALENDAR uses Embedded Services functions to compute column values for the following columns:
- day_of_month
- weekday_of_month
- month_of_quarter
- month_of_year
- quarter_of_year
- year_of_calendar