Calendar pattern routines
You can use calendar pattern routines to manipulate calendar patterns.
Calendar pattern routines can perform the following types
of operations:
- Create the intersection of calendar patterns
- Create the union of calendar patterns
- Alter a calendar pattern
Calendar and calendar pattern routines can be useful when comparing time series that are based on different calendars. For example, to compare peak time business usage of a computer network across multiple countries requires accounting for different sets of public holidays in each country. An efficient way to handle this is to define a calendar for each country and then create the calendar intersections to perform business-day comparisons.
Calendar pattern routines can be run in SQL statements or sent from an application using the DataBlade® API function mi_exec.