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.
Return values
The ifx_loadPartMart() function returns the text string "The operation was completed successfully." or an error message.
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');