ifx_TSDW_setCalendar() function

The ifx_TSDW_setCalendar function assigns a time series calendar to a time series virtual table in a data mart.

Syntax

ifx_TSDW_setCalendar(accelerator_name varchar(128),
                     data_mart_name   varchar(128),
                     table_owner      varchar(32),
                     table_name       varchar(128),
                     calendar_name    varchar(255))
returns lvarchar;

accelerator_name: The name of the accelerator.
datamart_name: The name of the data mart.
table_owner: The owner of the table.
table_name: The name of the table.

calendar_name: The name of the time series calendar.

Usage

Run the ifx_TSDW_setCalendar() function to assign a time series calendar to a time series virtual table in a data mart.

When you assign a calendar, the time series data is grouped into virtual partitions when it is loaded to the accelerator. The data mart must not be initially loaded, in the LoadPending state.

Return value

The ifx_TSDW_setCalendar() function returns the text string "The operation was completed successfully." or an error message.

Example

The following example assigns a time series calendar '2010monthly' to the time series virtual table 'informix'.'ts_data_v' in data mart 'datamart_name' on accelerator 'demo_dwa'.

execute function ifx_TSDW_setCalendar(
  'demo_dwa', 'datamart_name', 'informix', 'ts_data_v', '2010monthly');