MODIFY_LOADER_BD

Modify BDomain settings for a loader.

Parameter Name	Required	DefaultValue	Description
p_ldr_name	yes		LDR_NAME
p_bdomain	yes		BDOMAIN
p_src_db_name	yes		SRC_DB_NAME (null to keep unchanged, ‘ ‘ to clear value)
p_src_connection	yes		SRC_CONNECTION (null to keep unchanged, ‘ ‘ to clear value)
p_tsa_schema	yes		TSA_SCHEMA (null to keep unchanged)
p_tsa_table	yes		TSA_TABLE (null to keep unchanged)
p_active	yes		ACTIVE (null to keep unchanged)
p_bdate_epoch	yes		BDATE_EPOCH (null to keep unchanged, ‘ ‘ to clear value)
p_status_finished_offset	yes		STATUS_FINISHED_OFFSET (null to keep unchanged)
p_ext_bdate_sql_expr	yes		EXT_BDATE_SQL_EXPR (null to keep unchanged, ‘ ‘ to clear value)
p_bdate_ffdl_prev_day	yes		BDATE_FFDL_PREV_DAY (null to keep unchanged)
p_src_view_gen	yes		SRC_VIEW_GEN (null to keep unchanged, ‘ ‘ to clear value)
p_src_where_clause	yes		SRC_WHERE_CLAUSE (null to keep unchanged, ‘ ‘ to clear value)
p_ct_enabled	yes		CT_ENABLED (null to keep unchanged)
p_ct_group	yes		CT_GROUP (null to keep unchanged, ‘ ‘ to clear value)
p_split_max_degree	yes		max. parallel degree for import
p_split_on_load_abort	yes		split import if it results in an error due to connection abort
p_priority	yes		priority of loader, lower value means higher priority

Example

EXECUTE SCRIPT api_dbiadm.modify_loader_bd
           ( 'Loader1'           -- p_ldr_name
           , 'R32'               -- p_bdomain
           , 'src_db_name_value' -- p_src_db_name
           , 'ZDW_R32_A'         -- p_src_connection
           , 'tsa_schema_value'  -- p_tsa_schema
           , 'tsa_table_value'   -- p_tsa_table
           , null                -- 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
           , true                -- p_ct_enabled
           , 'MYTEST_CT'         -- p_ct_group
           , null                -- p_split_max_degree
           , null                -- p_split_on_load_abort
           , null                -- p_priority
           ) ;