Re: Date Warning message

[Jim Vanderpool <jim.vanderpool@CUSYS.EDU>]

Dave,
I have run into this with Oracle and PeopleSoft.  Your SQR is not picking up
a 4-digit mask from the .ini file, so it defaults to the DD-MON-YY format
for Oracle.

Make sure your -ZIF parameter points to your PSSQR.INI file.  Then, check
that file to be sure the following lines correctly specify the date format
you are using:

        [Environment:Oracle]
        SQR_DB_DATE_FORMAT=DD-MON-YYYY

If not, you'll need to change the mask to be correct for your standards.

Hope that helps,
Jim Vanderpool

At 09:18 AM 5/20/99 -0700, you wrote:
>Hi all,
>I like to know why i'm getting the following message when i try to run SQR on
>the server
>            Warning on line 2331:
>                (SQR 7501) Using YY edit mask from (DD-MON-YY) against (1999)
>Line#2331 = move &A.Pay_End_Dt to $AsOfDate
>
>SQR Ver: 4.3.2
>Platform: AIX 4.3
>RDBMS: Oracle 7.3.4
>PeopleSoft HRMS 7.01
>
>thanks
>dave
>
>