5. Manage BDomain Settings¶

Make sure that the BDomain already exists:

Add BDomain

5.1. Add DBI BDomain Settings¶

To add Bdomain specific DBI settings use API_DBIADM.ADD_BDOMAIN_SETTING. Currently the only parameter is the offset in hours if the change of business days should not occur at midnight, otherwise the default value will be used, which is 0.

Example: configure a 6-hour offset for BDomain ‘TESTING’

EXECUTE SCRIPT API_DBIADM.ADD_BDOMAIN_SETTING(
   'TESTING'   -- p_bdomain
   ,6          -- p_bdate_start_offset
);

Issuing this command results in a new entry in the table DBI_BDOMAIN_SETTINGS.

BDOMAIN	BDATE_START_OFFSET

TESTING	6

5.2. Modify DBI BDomain Settings¶

To modify the DBI BDomain settings use API_DBIADM.MODIFY_BDOMAIN_SETTING.

Example: change the offsaet back to zero

EXECUTE SCRIPT API_DBIADM.MODIFY_BDOMAIN_SETTING(
   'TESTING'   -- p_bdomain
   ,0          -- p_bdate_start_offset
);

After running the command above the entry for the bdomain ‘TESTING’ in the table DBI_BDOMAIN_SETTINGS will have changed.

BDOMAIN	BDATE_START_OFFSET

TESTING	0

5.3. Remove DBI BDomain Settings¶

To remove DBI bdomain settings for a bdomain use API_DBIADM.REMOVE_BDOMAIN_SETTING.

Example: remove BDomain settings from ‘TESTING’

EXECUTE SCRIPT API_DBIADM.REMOVE_BDOMAIN_SETTING(
   'TESTING'   -- p_bdomain
);

After issuing the command above the entry belonging to the bdomain ‘TESTING’ will have been removed from the table DBI_BDOMAIN_SETTINGS.