Re: Y2K

[Ken Gartman <osmium@EROLS.COM>]

Hi, Arnon!
        None needed!

        SQR is usually used with a modern database management system, such as
ORACLE.  ORACLE itself is completely Y2K compliant.  I guess that
Sybase,
Informix, and the others also are Y2K compliant.

        Many SQR reports show the run date in the upper right hand corner.
If it gives '042298', just change it to 22-Apr-1998, or something:

        BEGIN-SELECT
        'Run Date: ' || TO_CHAR( SYSDATE, 'fmDD-Mon-fmYYYY' ) RUN_DATE  ( 2,
{COL-RD} )
        FROM DUAL
        END-SELECT

        I doubt that any automatic tool can check for Y2K compliance.  Why?

        SQR is often used for converting old data from legacy mainframe systems
to
modern RDBMS systems.  As part of that process, if may read in dates in
text fields,
such as '220498', and insert them into an ORACLE date field.  The date
mask for
reading the old dates will not be Y2K-compliant, but the purpose of the
program is
to convert to to a Y2K-compliant format.  If an automated tool converted
the input
date mask to a Y2K-compliant format, the program would not function
properly!

        The best way to deal with dates is to make sure that dates are inserted
into
a database DATE field, not a TEXT (or CHARACTER, or ASCII, or STRING, or
VARCHAR ) field.


                                Happy computing,
                                Ken Gartman


SEMECH wrote:
>
> Hi !
>
> Does anyone have or know about automatic tool to check and fix sqr program
> for "Y2K compliance" ?
>
> Regards,
> Arnon Oppenheimer
> -------------------------------------------------------------------
> SEMECH SOFTWARE MARKETING LTD.
> TEL : (972) - 3 - 5333144
> FAX : (972) - 3 - 5333132
> Email: <semech@pobox.com>
> ------------------------------------------------------------------