5. Manage DBI BDomain Settings

Make sure that the BDomain exists: Add a BDomain.

5.1. Add DBI BDomain Settings

To add DBI-specific settings to a BDomain, use API_DBIADM.ADD_BDOMAIN_SETTING. Currently the only setting is p_bdate_start_offset: the offset in hours if the business day should not change at midnight (default 0).

Example: Configure a 6-Hour Offset for BDomain ‘TESTING’

1EXECUTE SCRIPT API_DBIADM.ADD_BDOMAIN_SETTING(
2    'TESTING'   -- p_bdomain
3   ,6           -- p_bdate_start_offset
4);

This command creates a new entry in the table DBIADM.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 Offset Back to Zero

1EXECUTE SCRIPT API_DBIADM.MODIFY_BDOMAIN_SETTING(
2    'TESTING'   -- p_bdomain
3   ,0           -- p_bdate_start_offset
4);

The entry for BDomain ‘TESTING’ in DBIADM.DBI_BDOMAIN_SETTINGS has changed:

BDOMAIN

BDATE_START_OFFSET

TESTING

0

5.3. Remove DBI BDomain Settings

To remove the DBI settings of a BDomain, use API_DBIADM.REMOVE_BDOMAIN_SETTING.

Example: Remove the Settings of BDomain ‘TESTING’

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

The entry of BDomain ‘TESTING’ is removed from DBIADM.DBI_BDOMAIN_SETTINGS.