Re: Year 2000 testing - aging Oracle data

Steve

I would be tempted to use Access(or something similar) to roll-forward all of the data.

If you connect to all of the tables i think you can then walk through the system tables using the Access dao. This data could be used to programmatically create a table showing table name, field names (of all date type fields), and some mask showing the relationships which must be upheld i.e only weekdays etc (when masking out days consider using bitwise manipulation).

A second piece of code could then be used to walk this table and create SQL queries (passthrough if req'd) to update the associated Oracle tables.

Hope this helps

Steve

SJPBooth <sjpbooth_at_aol.com> wrote in article <1998073012411500.IAA07360_at_ladder03.news.aol.com>...
> Hi,
>
> As part of the testing plan for Year 2000 work, it's necessary to age
dates in
> the Orcale databases so that they reflect dates in 1999, 2000, etc. It's
> important that the dates retain their interrelationships and that they
conform
> to rules like not falling on a weekend or holiday.
>
> Anybody else hit this? Any ideas?
>
> Thanks,
> Steve
>
Received on Mon Aug 03 1998 - 16:03:45 CDT