REMOVE_LOADER_BD¶

Remove specified DBI-Loader(BD) record(s).

Table: DBIADM.DBI_LOADER_BD (BDomain specific DBI loader definitions)

Prerequisites¶

Remove blocking PSA objects

Before executing REMOVE_LOADER, ensure that all PSA objects referencing the corresponding TSA objects have been removed. You can query the view CFIADM.CFI_API_REM_LDR_BLOCKING_OBJ to retrieve a list of these dependent objects.
```
SELECT *
  FROM dbiAdm.dbi_api_rem_ldr_blocking_obj
 WHERE ldr_name = :ldr_name;
```

Execute ``EMPTY_TSA``

Run the EMPTY_TSA procedure before executing REMOVE_LOADER to ensure the target TSA is empty and ready for removal.

EXECUTE SCRIPT api_dbiadm.empty_tsa
            ( p_dbi_ldr
            , p_bdomain
            );

EXECUTE SCRIPT api_dbiadm.remove_loader_bg
            ( p_ldr_name
            , p_bdomain
            );

Parameter Name	Properties	Parameter Description
p_ldr_name	(PK)(NN)	Name of the loader process for a specific data table as defined in DBI_LOADER.LDR_NAME (foreign key)
p_bdomain	(PK)(NN)	Name of the business domain as defined in DBI_BDOMAIN_SETTINGS.BDOMAIN (foreign key)

Example

EXECUTE SCRIPT api_dbiadm.remove_loader_bd
            ( 'XXXXXXXXXXXX'    -- p_ldr_name
            , 'XXXXXXXXXX'      -- p_bdomain
            );