6. Manage BDomain Metadata of a Loader

Make sure that a DBI loader already exists:

• Add DBI Loader

6.1. Add BDomain Specific Metadata to a Loader

To add BDomain specific metadata to a loader use API_DBIADM.ADD_LOADER_BD.

Most important parameters are

• the source connection, DB-name, schema and table name (or view name)

• with p_active false the loader is still inactive

Example

EXECUTE SCRIPT API_DBIADM.ADD_LOADER_BD(
   'TST_PERS_LDR'   -- p_ldr_name
   ,'TESTING'       -- p_bdomain
   ,'TESTING'       -- p_src_db_name
   ,'SQL_SERVER'    -- p_src_connection
   ,'DBITSA'        -- p_tsa_schema
   ,'TEST_PERSON'   -- p_tsa_table
   ,false           -- p_active
   ,null            -- p_bdate_epoch
   ,0               -- p_status_finished_offset
   ,null            -- p_ext_bdate_sql_expr
   ,false           -- p_bdate_ffdl_prev_day
   ,null            -- p_src_view_gen
   ,null            -- p_src_where_clause
   ,false           -- p_ct_enabled
   ,null            -- p_ct_group
   ,null            -- p_split_max_degree
   ,false           -- p_split_on_load_abort
   ,99              -- p_priority
);

After issuing the command above an entry is added to DBI_LOADER_BD. The table below shows some of the columns and added values of this table.

LDR_NAME	BDOMAIN	SRC_DB_NAME	SRC_CONNECTION	TSA_SCHEMA	TSA_TABLE	ACTIVE	BDATE_EPOCH	SPLIT_ON_LOAD_ABORT	PRIORITY
TST_PERS_LDR	TESTING	TESTING	SQL_SERVER	DBITSA	TEST_PERSON	false	(null)	false	99

6.2. Modify a BDomain Loader

To modify a BDomain loader use API_DBIADM.MODIFY_LOADER_BD. Providing NULL leaves the parameters as is, while a blank (’ ‘) restores the default value. As can be seen in the example below, only the value for the active variable should be changed, therefore a null value is used for the rest of the variables.

Example

EXECUTE SCRIPT API_DBIADM.MODIFY_LOADER_BD(
   'TST_PERS_LDR'   -- p_ldr_name
   ,'TESTING'       -- p_bdomain
   ,null            -- p_src_db_name
   ,null            -- p_src_connection
   ,null            -- p_tsa_schema
   ,null            -- p_tsa_table
   ,true            -- p_active
   ,null            -- p_bdate_epoch
   ,null            -- p_status_finished_offset
   ,null            -- p_ext_bdate_sql_expr
   ,null            -- p_bdate_ffdl_prev_day
   ,null            -- p_src_view_gen
   ,null            -- p_src_where_clause
   ,null            -- p_ct_enabled
   ,null            -- p_ct_group
   ,null            -- p_split_max_degree
   ,null            -- p_split_on_load_abort
   ,null            -- p_priority
);

This command results in a changed entry for the loader ‘PERSON’ with the BDomain ‘TESTING’ in the table DBI_LOADER_BD.

LDR_NAME	BDOMAIN	SRC_DB_NAME	SRC_CONNECTION	TSA_SCHEMA	TSA_TABLE	ACTIVE	BDATE_EPOCH	SPLIT_ON_LOAD_ABORT	PRIORITY
TST_PERS_LDR	TESTING	TESTING	SQL_SERVER	DBITSA	TEST_PERSON	true	(null)	false	99

6.3. Remove BDomain Specific Metadata from a Loader

To remove BDomain specific metadata from a loader use API_DBIADM.REMOVE_LOADER_BD.

Example

EXECUTE SCRIPT API_DBIADM.REMOVE_LOADER_BD(
   'TST_PERS_LDR'   -- p_ldr_name
   ,'TESTING'       -- p_bdomain
);

After having issued the command above, the entry for the loader ‘TST_PERS_LDR’ for the BDomain ‘TESTING’ will have been removed from the table DBI_LOADER_BD.