ifx_loadPartMart() function

The ifx_loadPartMart() function loads the data into one partition in a fragmented table or into a non-fragmented table.

Syntax

The data mart must be in an Active state.


>>-execute function ifx_loadPartMart---------------------------->

>--(--'accelerator_name'--,--'data_mart_name'--,--'table_owner'--,--'table_name'--,--'partition'--)-><

Parameters

accelerator_name: The name of the accelerator
data_mart_name: The name of the data mart.
table_owner: The owner of the table
table_name: The name of the table
partition: The name of the partition in a fragmented table or the name of the non-fragmented table. The value can also be a partition number that is represented as a string value. You can use the oncheck -pt command to look up the partition name, the table name, or the partition number.

Usage

Run the ifx_loadPartMart() function to refresh data in a partition or table after you run the ifx_dropPartMart() function. Include the same parameter values in both functions.

If you plan to use partial data refresh for data marts, including trickle feed, the value of the MAX_PDQPRIORITY configuration parameter must be set to 50 or greater during the initial data load and partial data refresh.

Important: Do not run the ifx_loadPartMart() function while trickle feed is enabled.

Return values

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

Note: Use the SQL statement set environment use_dwa 'loadpdq <value>'; in the same database session before calling the ifx_loadPartMart() function to set the PDQPRIORITY for the database sessions that extract the data from the database tables. The value for parameter "loadpdq" is a positive integer between 0 and 100 (inclusive), default being 2.

Examples

The following example loads the data in partition 'part1' of the fragmented table 'tab22'.

execute function ifx_loadPartMart('myAccelerator','myMart','user10','tab22',
'part1');

The following example loads the data in partition '0x100124' of the fragmented table 'tab22'.

execute function ifx_loadPartMart('myAccelerator','myMart','user10','tab22',
'0x100124');

The following example loads the data in the non-fragmented table 'tab22'. In this example, the table name 'tab22' is used for both the table_name parameter and for the partition parameter.

execute function ifx_loadPartMart('myAccelerator','myMart','user10','tab22',
'tab22');