ifx_def2Mart() procedure
The ifx_def2Mart() procedure uses the ifx_getMartdef() function to retrieve the data mart definition from an accelerator. It then uses the ifx_xml2Mart() procedure to store the data mart definition XML file in the data mart schema tables.
Syntax
- accelerator_name
- The name of the accelerator.
- data_mart_name
- The name of the data mart.
- database_name
- If you include the database name, the procedure checks that all the tables and columns that are contained in the data mart definition are present in the database.
Usage
The ifx_def2Mart() procedure retrieves the data mart definition from the accelerator and stores it in the data mart schema tables. The following table lists the data mart schema tables.| Table | Description |
|---|---|
| 'informix'.iwa_marts | Names of the data mart definitions |
| 'informix'.iwa_tables | All of the tables that are used in any data mart definition |
| 'informix'.iwa_columns | All of the columns that are used in any data mart definition |
| 'informix'.iwa_mtabs | Tables for a specific data mart definition |
| 'informix'.iwa_mcols | Columns for a specific data mart definition |
| 'informix'.iwa_mrefs | References (join descriptors) of a specific data mart definition |
| 'informix'.iwa_mrefcols | Reference columns (join predicates) of a specific data mart definition |
Examples
This example shows how to retrieve
the definition of data mart 'Datamart1' from the
accelerator 'MyAccelerator', and then store it in
the data mart schema tables of a newly created database 'martSchemaDB'.
The procedure checks that the tables and columns that are referenced
in the data mart definition exist in database 'database1'.
CREATE DATABASE 'martSchemaDB';
EXECUTE procedure ifx_def2Mart('MyAccelerator', 'Datamart1', 'database1');