REFRESH_LOADERΒΆ
Change the TSA table structure if loader columns have changed.
Parameter Name |
Required |
DefaultValue |
Parameter-Description |
---|---|---|---|
p_ldr_name |
no |
Name of the loader process for a specific data table as defined in CFI_LOADER.LDR_NAME (null used to execute script for all loaders) |
|
p_bdomain |
no |
Name of the business domain as defined in CFI_BDOMAIN_SETTINGS.BDOMAIN (null used to execute script for all loaders) |
|
p_force |
yes |
false |
force execution of DDL result statements, false just generates an output |
Example
execute script api_cfiadm.refresh_loader
( 'XXXXXXXXXXXX' -- p_ldr_name
, 'XXXXXXXXXX' -- p_bdomain
, false -- p_force
)