ifx_setMart() function

The ifx_setMart() function changes the state of a data mart from Active to Disabled or from Disabled to Active.

Syntax


1  ifx_setMart ( ' accelerator_name ' , ' data_mart_name ' ,  '
2.1 OFF
2.1 ON
1 ' )
accelerator_name
The name of the accelerator.
data_mart_name
The name of the data mart.
OFF
Changes the state of the data mart state from Active to Disabled. This parameter is case-sensitive.
ON
Changes the state of the data mart state from Disabled to Active. This parameter is case-sensitive.

Usage

To determine the state of a data mart, use the ifx_getMartStat() function. The ifx_setMart() function returns an error if the data mart is in a state other than Active or Disabled.

When the data mart is in the Active state, the data mart is available for query processing.

When the data mart is in the Disabled state, the data mart is not available for query processing.

Return value

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

Examples

The following example shows how to change a data mart that is in the Active state to the Quiesced state.

EXECUTE FUNCTION ifx_setMart('MyAccelerator', 'Datamart1' 'OFF');

The following example shows how to change a data mart that is in the Disabled state to the Active state.

EXECUTE FUNCTION ifx_setMart('MyAccelerator', 'Datamart1' 'ON');