| Michael Mattias 2007-04-09, 6:55 pm |
| > I have a requirement as follows:
>
> I have a COBOL+DB2 program that inserts data into a DB2 table when an
> order is placed. Now, The same data should be inserted into the same
> table after every 7 days until a condition is met. This means I need
> to insert same data after every 7 days until the order is approved/
> denied.
>
> Any help would be highly appreciated.
This is apparently some kind of 'holding' area for new orders, where they
are reviewed prior to acceptance.
Wouldn't it be a lot simpler to just store a "date entered" in this table
and run a batch program every day to find those which are more than 'x' days
old and then do something with those which are? (You may need to add some
kind of 'counter' or 'last reminder date' column, too). Not to mention, if
seven (7) days doesn't work out as a good number, changing it to some other
number of days will be a lot more straightforward to accomplish.
MCM
|