Re: Question: How will the Year 2000 bug impact your work?
Posted in 1996
Topics: Triggers, Constraints & Referential Integrity
In article <326FE58A.18ED@ici.net> Alicia Carla Longstreet <carla@ici.net> writes: >: Also, what happens if YOUR suppliers don't become Date 2000 >: compliant?? Will your business survive if you can't use your EDI >: links. Simpler still, what if the supplier of your core products can >: no longer find your order in their system because it was put entered >: in 1999 and now the system thinks it was put in with a date 99 years : >into the future?? > >: Colin Thompson >: Colin_Thompson@perth.ccmail.compuserve.com >Good Point!!! >Alicia Yes, Alicia and Colin, it's a good point but somewhat of a doomcryer. Obviously systems must be reviewed to ensure that they will handle date translation and storage and dry-runs of EDI and other mission-critical systems ought to be begun promptly. I expect that no one worth his salt would ever have knowingly designed a system such as EDI to have this problem but in any case EVERY company that is now dependent upon EDI, both suppliers and clients, will have to ensure that things like this will in fact run smoothly. As for the "I can't find your order" problem, it's worth noting that queries can, and no doubt will, be run to ensure that dates are in-bounds and that triggers, validity checks and other mechanisms are probably already in place now. After all, it would not do for an order to be entered with a date of, say, 1978, any more than 2099. Order entry systems probably already -have- date checks of this sort .. they simply -have- to. /mr/