RICHINMINN
Programmer
- Dec 31, 2001
- 138
I work in an IBM mainframe environment (z/OS, COBOL 2 and 3, DB2, etc.). I need to write a COBOL program to do an aging report of batches of data that are being processed. There are 4 steps that have to be completed, and these steps can span multiple days, though most data will complete all 4 steps within the same day. I need to see the batches that are not completely done, and how many business days it has taken them so far.
Does anyone have a handy algorithm for calculating the number of business days elapsed between, say, the current date, and the date that a batch of data most recently completed one of its 4 steps, which will, of course, take into account weekends and holidays?
The batch information is found on a DB2 table, with a timestamp field that is updated each time that the batch completes one of the four steps.
I realize that this description of the problem is a bit vague, but thanks for bearing with me.
Rich (in Minn.)
Does anyone have a handy algorithm for calculating the number of business days elapsed between, say, the current date, and the date that a batch of data most recently completed one of its 4 steps, which will, of course, take into account weekends and holidays?
The batch information is found on a DB2 table, with a timestamp field that is updated each time that the batch completes one of the four steps.
I realize that this description of the problem is a bit vague, but thanks for bearing with me.
Rich (in Minn.)