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.