ifx_TSDW_updatePartition() function

The ifx_TSDW_updatePartition function refreshes the time series data within a time series virtual table in a data mart.

Syntax

ifx_TSDW_updatePartition(accelerator_name varchar(128),
                         data_mart_name   varchar(128),
                         table_owner      varchar(32),
                         table_name       varchar(128),
                         calendar_index   integer)
returns lvarchar;

ifx_TSDW_updatePartition(accelerator_name varchar(128),
                         data_mart_name   varchar(128),
                         table_owner      varchar(32),
                         table_name       varchar(128),
                         time_stamp            datetime year to fraction(5))
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_index: The calendar index that identifies the virtual partition that is refreshed. The value must be greater than or equal 0.
time_stamp: The time stamp that identifies the virtual partition that is refreshed. The value must be greater than or equal to the start time stamp of the calendar that is assigned to the table.

Usage

Run the ifx_TSDW_updatePartition() function to refresh the time series data of a virtual partition within a time series virtual table in a data mart.

If the time series virtual table has time windows, the virtual partition must exist in one of the time windows. If a virtual partition is refreshed in an active data mart, the time series data is refreshed immediately. Depending on the volume of data, this load can take a significant amount of time.

Return values

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

Example

The following example refreshes time series data for the time series virtual table 'informix'.'ts_data_v' in data mart 'datamart_name' on accelerator 'demo_dwa'. A calendar with a start time stamp of '2010-01-01 00:00:00.00000' and a pattern of one month is set for this table.

The following example refreshes the data for January 2011.

execute function ifx_TSDW_updatePartition(
  'demo_dwa', 'datamart_name', 'informix', 'ts_data_v',
  '2011-01'::datetime year to month);

The following example refreshes the data for March 2011.

execute function ifx_TSDW_updatePartition(
  'demo_dwa', 'datamart_name', 'informix', 'ts_data_v', 14);