Data Center Management Systems
Date Control System - Technical Overview
|
|
- Access Routine – Provides date calculation services to calling application programs
- Utility Program – Batch utility is used to define calendars for Access Routine and JOBDATE Facility
- JOBDATE Facility – Provides two mechanisms for automating date handling in batch applications
| Command | Description | Input | Output | Calendar | |
| AD | Advance Date by specified days | MMDDYY | MMDDYY+nnn | ||
| AWD | Advance Working Days by specified days using holiday calendar | MMDDYY | MMDDYY+nnn | HOLIDAY | |
| BD | Backspace Date by specified days | MMDDYY | MMDDYY+nnn | ||
| BWD | Backspace Working Days by specified days using holiday calendar | MMMMDDYYDDYY | HOLIDAY | ||
| CURR | Return current system date and time | MMDDYY HHMMSS | |||
| DBD | Return number Days Between 2 Dates | MMDDYY | nnn | ||
| DAYS | Days Remaining in calendar Year | MMDDYY | nnn | ||
| DDMM | Shift DDMMYY to MMDDYY | DDMMYY | MMDDYY | ||
| DDYY | Shift DDMMYY to YYMMDD | DDMMYY | YYMMDD | ||
| DOW | Return Day of the Week | MMDDYY | MONDAY-SUNDAY | ||
| ED | Edit (validate) Date | MMDDYY | coded | ||
| EP | Elapsed Periods, returns period (month) number within fiscal calendar | MMDDYY | nnn | FISCAL | |
| EXP | Expand Date, returns written date | MMDDYY | January 4, 2017 | ||
| FPWN | Fiscal Period Week Number, returns week number within fiscal month | MMDDYY | nnn | ||
| FYWN | Fiscal Year Week Number, returns week number within fiscal year | MMDDYY | nnn | ||
| GJ | Converts date from Gregorian to Julian formats | MMDDYY | YYDDD | ||
| GJYY | Gregorian to Julian - 4-digit year | MMDDYYYY | YYYDDD | ||
| IS | Insert Slashes | MMDDYY | MM/DD/YY | ||
| ISYY | Insert Slashes - 4-digit year | MMDDYYYY | MM/DD/YYYY | ||
| JG | Convert date from Julian to Gregorian formats | YYDDD | MMDDYY | ||
| JGYY | Julian to Gregorian - 4-digit year | YYYYDDD | MMDDYYYY | ||
| MBD | Returns Month Beginning Date for specified date | MMDDYY | MMDDYY-ddd | ||
| MED | Returns Month Ending Date for specified date | MMDDYY | MMDDYY-ddd | ||
| MMDD | Shift MMDDYY to DDMMYY | MMDDYY | DDMMYY | ||
| MMYY | Shift MMDDYY to YYMMDD | MMDDYY | YYMMDD | ||
| PBD | Returns Period Beginning Date for specified date in fiscal calendar | MMDDYY | MMDDYY-ddd | FISCAL | |
| PED | Returns Period Ending Date for specified date in fiscal calendar | MMDDYY | MMDDYY+ddd | FISCAL | |
| RET | Retrieve Date from stored array | MMDDYY | |||
| RS | Remove Slashes | MM/DD/YY | MMDDYY | ||
| RSYY | Remove Slashes - 4-digit year | MM/DD/YY YY | MMDDYYYY | ||
| UPD | Update Date into stored array | MMDDYY | |||
| WD | Working Day Inquiry, answers “is this date a non-holiday?” | MMDDYY |
|
HOLIDAY | |
| WDBD | Returns number of Working Days Between 2 Dates using holiday calendar | MMDDYY | nnn | HOLIDAY | |
| YYMM | Shift YYMMDD to MMDDYY | YYMMDD | MMDDYY |
The DCS Utility program is used to:
- Define HOLIDAY and FISCAL calendars. Calendars are defined for a specific year and an 8-character “application”.
- Store JOBDATE codes when using the JOBDATE Program Method.
- Define storage for application-specific dates (or other numeric data). Up to 10,000 dates can be maintained for each 8-character “application”.
Command |
Description |
Category |
CALENDAR |
Initialize holiday calendar for one year |
HOLIDAY |
DELETE HOLIDAY |
Delete holiday calendar |
HOLIDAY |
DISPLAY HOLIDAYS |
Show all stored holidays for calendar |
HOLIDAY |
PASSWORD HOLIDAY |
Set or change calendar password |
HOLIDAY |
PRINT HOLIDAY |
Create printable annual holiday calendar |
HOLIDAY |
WORKINGDAY |
Correct days on holiday calendar |
HOLIDAY |
|
|
|
FISCAL |
Initialize fiscal calendar for one year |
FISCAL |
ADJUST |
Correct fiscal calendar ending period |
FISCAL |
DELETE FISCAL |
Delete fiscal calendar |
FISCAL |
PRINT FISCAL |
Create printable annual fiscal calendar |
FISCAL |
PASSWORD FISCAL |
Set or change calendar password |
FISCAL |
|
|
|
JOBDATE |
Store JOBDATE code or actual date |
JOBDATE |
DISPLAY JOBDATES |
Show all JOBDATES |
JOBDATE |
|
|
|
CONTROL |
Initialize data storage array for application |
DATES |
DISPLAY DATES |
Show data storage array for application |
DATES |
PASSWORD DATE |
Set or change array password |
DATES |
PROTECT |
Set or change password on data array element |
DATES |
RESTORE |
Revert data array to previous generation |
DATES |
SETDATE |
Set value for application data array element |
DATES |
DCS’s JOBDATE facility lets you automate the handling of dates within batch processing. Two methods are provided for implementing JOBDATE:
- Program Method - Change your programs to call the JOBDATE routine to obtain the process date
- JCL Method - Change your jobs to insert a calculated date into a data stream.
Many JOBDATE codes are pre-defined as shown below. To meet your site-specific needs, user-defined codes can be added easily.
Category |
Code |
Condition |
Description |
Sample Input |
Sample Output |
CALENDAR |
BMnn |
Always |
Backspace 'nn' months |
BM02 on 10/02/16 |
8/02/2016 |
CALENDAR |
FMnn |
Always |
Forward space 'nn' months |
FM07 on 06/02/16 |
01/02/2007 |
CALENDAR |
LMBD |
Always |
Previous month's month-begin date |
4/8/2016 |
3/1/2016 |
CALENDAR |
LMED |
Always |
Previous month's month-ending date |
4/8/2016 |
3/31/2016 |
CALENDAR |
NMBD |
Always |
Next month's month-begin date |
4/8/2016 |
5/1/2016 |
CALENDAR |
NMED |
Always |
Next month's month-ending date |
4/8/2016 |
5/31/2016 |
CALENDAR |
SABD |
Always |
Semi-Annual begin date just ended |
7/2/2016 |
1/1/2016 |
CALENDAR |
SAED |
Always |
Semi-Annual ending date just ended |
7/2/2016 |
6/30/2016 |
CALENDAR |
TMBD |
Always |
Current month's month-begin date |
4/8/2016 |
4/1/2016 |
CALENDAR |
TMED |
Always |
Current month's month-ending date |
4/8/2016 |
4/30/2016 |
CURR |
CURR * |
Always |
Current date |
2/14/2016 |
2/14/2016 |
CURR |
DALY * |
06:00 - 23:59 |
Current date |
2/14/2016 13:30 |
2/14/2016 |
CURR |
DALY * |
00:00 - 05:59 |
Yesterday's date |
2/14/2016 1:30 |
2/13/2016 |
CURR |
NOON * |
12:00 - 23:59 |
Today's date |
2/14/2016 14:30 |
2/14/2016 |
CURR |
NOON * |
00:00 - 11:59 |
Yesterday' date |
2/14/2016 2:30 |
2/13/2016 |
FRI |
AFRI |
Always |
Advance to Friday |
Today is Friday |
Next Friday's date |
FRI |
BFRI |
Always |
Backspace to Friday |
Today is Friday |
Last week |
FRI |
LFRI |
Always |
Last Friday's date |
Today is Friday |
Today's date |
FRI |
NFRI |
Always |
Next Friday's date |
Today is Friday |
Today's date |
HOLIDAY |
LBD * |
Always |
Last business (non-holiday) day |
6/2/2016 |
6/1/2016 |
HOLIDAY |
NBD * |
17:00 - 23:59 |
Next business date |
6/7/2016 17:30 |
6/8/2016 |
HOLIDAY |
NBD * |
00:00 - 16:59 |
Current date |
6/7/2016 16:30 |
6/7/2016 |
HOLIDAY |
NBD * |
On a holiday |
Next business (non-holiday) day |
6/3/2016 5:30 |
6/5/2016 |
MON |
AMON |
Always |
Advance to Monday |
Today is Monday |
Next Monday's date |
MON |
BMON |
Always |
Backspace to Monday |
Today is Monday |
Last week |
MON |
LMON |
Always |
Last Monday's date |
Today is Monday |
Today's date |
MON |
NMON |
Always |
Next Monday's date |
Today is Monday |
Today's date |
MON |
TMON |
Always |
Next Monday's date |
Today is Monday |
Today's date |
FISCAL |
LPBD |
Always |
Last period begin date |
|
|
FISCAL |
LPED |
Always |
Last period end date |
|
|
FISCAL |
LPYY |
Always |
Last period number and year |
|
|
FISCAL |
NPBD |
Always |
Next period begin date |
|
|
FISCAL |
NPED |
Always |
Next period end date |
|
|
FISCAL |
QTR# |
Always |
Quarter number of period just ended |
5/31/2016 |
2 |
FISCAL |
TPBD |
Always |
Current period begin date |
|
|
FISCAL |
TPED |
Always |
Current period end date |
|
|
FISCAL |
TPYY |
Always |
Current period number and year |
|
|
SAT |
ASAT |
Always |
Advance to Saturday |
Today is Saturday |
Next Saturday's date |
SAT |
BSAT |
Always |
Backspace to Saturday |
Today is Saturday |
Last week |
SAT |
LSAT |
Always |
Last Saturday's date |
Today is Saturday |
Today's date |
SAT |
NSAT |
Always |
Next Saturday's date |
Today is Saturday |
Today's date |
SUN |
ASUN |
Always |
Advance to Sunday |
Today is Sunday |
Next Sunday's date |
SUN |
BSUN |
Always |
Backspace to Sunday |
Today is Sunday |
Last week |
SUN |
LSUN |
Always |
Last Sunday's date |
Today is Sunday |
Today's date |
SUN |
NSUN |
Always |
Next Sunday's date |
Today is Sunday |
Today's date |
THU |
ATHU |
Always |
Advance to Thursday |
Today is Thursday |
Next Thursday's date |
THU |
BTHU |
Always |
Backspace to Thursday |
Today is Thursday |
Last week |
THU |
LTHU |
Always |
Last Thursday's date |
Today is Thursday |
Today's date |
THU |
NTHU |
Always |
Next Thursday's date |
Today is Thursday |
Today's date |
TUE |
ATUE |
Always |
Advance to Tuesday |
Today is Tuesday |
Next Tuesday's date |
TUE |
BTUE |
Always |
Backspace to Tuesday |
Today is Tuesday |
Last week |
TUE |
LTUE |
Always |
Last Tuesday's date |
Today is Tuesday |
Today's date |
TUE |
NTUE |
Always |
Next Tuesday's date |
Today is Tuesday |
Today's date |
WED |
AWED |
Always |
Advance to Wednesday |
Today is Wednesday |
Next Wednesday's date Tomorrow's date |
WED |
BWED |
Always |
Backspace to Wednesday |
Today is Wednesday |
Last week |
WED |
LWED |
Always |
Last Wednesday's date |
Today is Wednesday |
Today's date |
WED |
NWED |
Always |
Next Wednesday's date |
Today is Wednesday |
Today's date |
DCS Administrator Guide
DCS User Guide
DCS Upgrade Guide
