Re: Y2K issues

[sgour <sgour@STOCKHOLDING.COM>]

Thanx Dan,

It was really helpful. As you rightly assumed, it was the ORACLE NLS date
format that
I had changed to RR. I will look into all my programs as told by you and
mask them
with a to_date function. Thanx again.

Saurabh.
***************************************************************************
************************





"Johnson, Dan" <Dan_Johnson@WRIGHTEXPRESS.COM> on 27.12.99 19:01:09

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: sgour/aplnmum01/SHCIL/IN)

Subject:  Re: Y2K issues




Hi Saurabh,
        When you say that you did the Oracle 'RR' thing I assume that you
mean you changed your Oracle NLS date format. This will take care of
inserts
into the data base and most other stuff where you are dealing directly with
Oracle functions that do not have SQR variables involved. Be careful when
using the Oracle between function on dates that have been assigned to SQR
variables. Make sure that you mask the variables using the to_date function
like to_date(&some_date,'dd-mon-rr') or what ever your default date mask
is.
You will also need to do this where any comparison operators are used in
your SQL queries, such as >=, < etc. Hope this helps.

Dan.

        ******************************************
        Hello Everybody.

        I have recently been assigned a task where SQRIBE is used for the
report
        purposes. The project has not gone live as of now and so this area
was a
        little neglected. Thus this delay in the following action.

        Being a naive user, I have tried to fine out the version of SQRIBE
that I
        am using and the resultant reply that I am getting is :
        " SQR/4.0.2/IBM RS6000/AIX 4.1/Oracle 7.2.3/....."

        Hope this clarifies the platform on which I am working.

        What I would like to know is  -  what do I have to check/ensure to
be sure
        of SQRIBE working fine in Y2K. I have done the masking for ORACLE
to
'RR'
        and I want to know what else I have to do for SQRIBE.

        Regards and wish you all a merry Xmas !!.

        Saurabh.