TOGGLE_LOADER_BDΒΆ

Toggle the DBI-Loader(BD) status between active and inactive.

Table: DBI_LOADER_BD (Business domain specific DBI loader settings for each table. Generic DBI loader settings for each table are stored in table DBIADM.DBI_LOADER).

Parameter Name

Properties

Default Value

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.toggle_loader_bd
            ( 'XXX'           -- p_ldr_name
            , 'XXX'           -- p_bdomain
            );