The current versions (Sys_Calendar.CALENDAR and Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE) use embedded services system functions to compute some column values. The Sys_Calendar.CALENDAR_TD1310 version computes all column values using arithmetic, which generally takes less time than computing values using UDFs.
To use the legacy TD1310 version of the view, replace the definition of Sys_Calendar.CALENDAR with the definition of Sys_Calendar.CALENDAR_TD1310. Follow these steps:
- Use this statement to view the definition of the Sys_Calendar.Calendar_TD1310 version:
SHOW VIEW Sys_Calendar.Calendar_TD1310;
- Use REPLACE to replace the definition of Sys_Calendar.CALENDAR with the definition of the Sys_Calendar.CALENDAR_TD1310 version.
After you redefine the current version, it no longer uses embedded services system functions to compute column values for the following columns: