ifx_createMart() function

There are two types of ifx_createMart() functions and each type takes different parameters.

• A type that creates a data mart that is based on a data mart definition that is in XML format. You create the data mart definition by using workload analysis. The ifx_createMart() function retrieves the data mart definition as a CLOB data type.
• A type that creates a data mart that is based on the schema of the database tables that you create with the ifx_probe2Mart() procedure.

Syntax

• Here is the syntax that is used to create a data mart that is based on a data mart definition.

  
  >>-ifx_createMart--(--'--accelerator_name--'--,--data_mart_definition--)-><
  
  

  accelerator_name

  The name of the accelerator where you want to create the data mart.

  data_mart_definition

  The data mart definition. The name of the data mart is retrieved from mart name attribute of the data mart definition. Valid data mart names have a maximum of 128 characters. Data marts names must be unique in an accelerator.

• Here is the syntax that is used to create the data mart definition and create the data mart. The data mart definition is based on the database tables that you create with the ifx_probe2Mart() procedure.

  
  >>-ifx_createMart--(--'--accelerator_name--'--,--'--data_mart_name--'--,--'--probe_database--'--)-><
  
  

  accelerator_name

  The name of the accelerator where you want to create the data mart.

  data_mart_name

  The name of the data mart. Valid data mart names have a maximum of 128 characters. Data marts names must be unique in an accelerator.

  probe_database

  The name of the database that contains the data mart schema tables. If you omit the probe_database parameter, the data mart schema tables must be in the current database.

Usage

You must create an accelerator before you can run the ifx_createMart() function.

Return value

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

EXECUTE FUNCTION ifx_createMart('MyAccelerator', filetoclob
('orders_customer_mart.xml', 'client'));

EXECUTE FUNCTION ifx_createMart('MyAccelerator', 'customermart1', 'stores_marts');