TV 3.7.0
¶ 1. Add CFI Loader
To add a loader for file imports the script API_CFIADM.ADD_LOADER is used. Here, one only has to provide a name for the loader as well as the priority the loader should have, the number of days data should remain in a TSA table before being removed and if ultimo shift should be used or not.
It is important to know that the lower the value for the priority is set, the higher of a priority the loader actually has.
¶ Example
EXECUTE SCRIPT API_CFIADM.ADD_LOADER(
'PERSON' -- p_ldr_name
,null -- p_tsa_retention
,99 -- p_priority
,true -- p_use_ultimo_shift
);
Issuing this command results in a new entry in the table CFIADM.CFI_LOADER.
| ldr_name | tsa_retention | priority | use_ultimo_shift |
|---|---|---|---|
| PERSON | null | 99 | true |
¶ 2. Modify CFI Loader
If one wants to modify the CFI loader parameters, the script API_CFIADM.MODIFY_LOADER can be used. While the name of the loader which should be modified has to be provided and therefore cannot be changed, one can change the parameters for the priority, the retention period and if ultimo shift should be used. Furthermore, a parameter for the business version which has been valid, when the loader entry was last changed exists as well. By providing a null for any of these values, the current value will be retained.
The following example shows such a modification. In this case the retention period will be changed and ultimo shift deactivated, while the priority stays the same.
¶ Example
EXECUTE SCRIPT API_CFIADM.MODIFY_LOADER(
'PERSON' -- p_ldr_name
,3 -- p_tsa_retention
,null -- p_priority
,false -- p_use_ultimo_shift
,null -- p_bv_changed
);
After running the command above the entry for the loader 'PERSON' in the table CFIADM.CFI_LOADER will have changed as can be seen below.
| ldr_name | tsa_retention | priority | use_ultimo_shift |
|---|---|---|---|
| PERSON | 3 | 99 | false |
¶ 3. Remove CFI Loader
To remove a CFI loader one only has to provide the name of the loader that should be removed to the script API_CFIADM.REMOVE_LOADER as can be seen in the example below.
¶ Example
EXECUTE SCRIPT API_CFIADM.REMOVE_LOADER(
'PERSON' -- p_ldr_name
);
After issuing the command above the entry belonging to the loader 'PERSON' will have been removed from the table CFIADM.CFI_LOADER.