7.3.2 Loading Non-business Days
After obtaining non-business days (or weekly off-days; typically Saturday and Sunday)
from an Oracle client, load this information for the upcoming calendar year into the
KDD_CAL_WKLY_OFF table.
The following text provides an example of an SQL script for loading the
table.:
INSERT INTO KDD_CAL_WKLY_OFF (CLNDR_NM, DAY_OF_WK) VALUES
(
'SYSCAL', 1);
INSERT INTO KDD_CAL_WKLY_OFF (CLNDR_NM, DAY_OF_WK) VALUES
(
'SYSCAL', 7);
COMMIT;Note:
By default, the system identifies Saturdays and Sundays as nonbusiness days in the system calendar (SYSCAL).Table 7-2 KDD_CAL_WKLY_OFF
| Column Name | Description |
|---|---|
| CLNDR_NM | Specific calendar name. |
| DAY_OF_WK | Value that represents the day of the week: Sunday=1, Monday=2, Tuesday=3,Wednesday=4, Thursday=5, Friday=6, Saturday=7. |
Note:
If the table does not contain records for any calendar in the list, the system logs a Warning message that the specific calendar contains no weekly off-days.