Hi Donna,
        Before Bypass existed, I wrote for the company I'm contracted to, an
analysis tool to scan and flag all source lines that may have had anything
to do with dates.
        The idea was that you then went in and manual changes as required.
        We started a project with this tool. Then we heard of Bypass and I went 
to
a course. I came back from course and modified tool to do interface to
Bypass.
        Never did get to complete it. It would have done conversions of dates to
any format including date type fields. Shame..
        Any way the tool we have does a database analysis using specific types 
to
search for.
So you say all 2 digit fields, 4 digit fields any fields with DT in the
name, or DATE in the description.
It is an inclusive tool. No fancy "If 2 long and contains whatever"
It's a tool for use by dumb programmers like me. It got the job done.
Once it's found all dates in your database, you scroll through a subfile
putting an N against the ones that are not dates.. quite easy.
You then take an option so the program runs off and checks the field
contents for the fields you have flagged as dates and then attempts to
determine the date format.
Again back to the subfile an F against the field and see if the format is
ok. Confirm the format and voila, you have a list for fields to take to
Bypass.
Take another option, up pops a window, asks for your xxxDB lib and your
xxxDAT lib then transfer the date seed across.


        Yes we have the same problem with files that span applications. The only
thing to do is to duplicate them. And try keep track of the various team
members on various applications..


krisV

-----Original Message-----
From:   owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]
On Behalf Of Zukowski, Donna
Sent:   Thursday, 28 May 1998 0:15
To:     'MIDRANGE-L@midrange.com'
Cc:     'Kris Vaidyanathan'
Subject:        RE: Bypass2000 : Bringing the millennium

Hi, Kris!  I'd be interested in hearing about your front-end tool.

We are using Search2000 and Bypass2000 in our conversion effort.  We've
had a few issues (Bypass won't convert CLP's and it doesn't convert 7,0
CYYMMDD date fields to 8,0 YYYYMMDD), but overall the project is
progressing as well as one can expect.  The changes are just grunt work.
What I find the most challenging is the determination of which
applications to work on in which order.  There are very few systems that
are stand alone and do not interface with others in some way.  We have
files that are used across almost all applications, but we can't change
the entire system in one shot.  Quite a dilemma, but one that I see
taking shape.

Donna Zukowski
Year 2000 Project Manager
BIC Corporation

> -----Original Message-----
> From: Kris Vaidyanathan [SMTP:krishnan@ozemail.com.au]
> Sent: Wednesday, May 27, 1998 9:15 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Bypass2000 : Bringing the millennium
>
> Hello,
>       Doing Y2k change using Bypass and a front end tool I wrote.
>
>       Has anybody got a project finished using Bypass?
>
>       Any tips..(apart from why did you take this on?)
>
>       KrisV
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].