ifx_setMart() function
The ifx_setMart() function changes the state of a data mart from Active to Disabled or from Disabled to Active.
Syntax
>>-ifx_setMart--(--'--accelerator_name--'--,--'--data_mart_name--'--,--'--+-OFF-+--'--)->< '-ON--'
- 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');