ifx_dropPartMart() function
The ifx_dropPartMart() function removes the data in one partition in a fragmented table or all of the data from a non-fragmented table.
Syntax
The
data mart must be in an Active state.
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
If you want to refresh data in a partition or table, run the ifx_dropPartMart() function to remove the stale data, and then run the loadPartMart() function to load new data. If you want to remove a partition, run the ifx_dropPartMart() function to remove the data, and then detach the partition from the database.
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_dropPartMart() function returns the text string "The operation was completed successfully." or an error message.
Examples
The following example drops the
data in partition 'part1' in the fragmented table 'tab22'.
execute function ifx_dropPartMart('myAccelerator','myMart','user10','tab22',
'part1');The following example drops the data in partition '0x100124' in
the fragmented table 'tab22'.
execute function ifx_dropPartMart('myAccelerator','myMart','user10','tab22',
'0x100124');The following example drops 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_dropPartMart('myAccelerator','myMart','user10','tab22',
'tab22');