Re: SQR 4.3.2 date problem

[Allen Wong <awong01@YAHOO.COM>]

Don,

Thanks for the reply.  I added the alter-locale - and it is still not
working for me.  The sqr is still complaining about the 7501 error.
-------------------------------------------------------
begin-setup
begin-sql
   alter session set nls_date_format = 'DD-MON-YYYY'
end-sql
end-setup

begin-program
 do Select-Parameters
end-program

begin-procedure Select-Parameters
  alter-locale
  date-edit-mask = 'DD-MON-YYYY'

begin-select
emplid
effdt

   print &effdt  (+1,1)

from ps_job RunCntl
end-select
end-procedure
-------------------------------------------------------

SQR V4.3.2
Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights
Reserved.

Warning on line 19:
   (SQR 7501) Using YY edit mask from (DD-MON-YY) against (1996)

-------------------------------------------------------

I know I can fix the error by retrieving the effdt with
to_char(effdt,'DD-MON-YYYY') however this will require changing
hundreds of sqrs.  Anymore suggestions -

thanks
allen



---Don Mellen <donm@ONTKO.COM> wrote:
>
> On Thu, 21 Jan 1999, Allen Wong wrote:
>
> > I am encountering the following problems for SQR 4.3.2 on Oracle
> > 7.3.4.1.  This is affecting alot of my sqrs for PeopleSoft.  I have
> > recently upgraded from PeopleTools 7.02 to PeopleTools 7.04 which
> > included SQR 4.3.2
> >
> > The date output I am expecting should be in
> > DD-MON-YYYY format, however in SQR 4.3.2 I am
> > recieving DD-MON-YY format.
>
> In ver 4.3.2, the date column (&effdt) is stored internally as a date,
> your show statement is translating that date to a string in the normal
> default format for whichever database you're connected to.  You
might want
> to check out the DATE-EDIT-MASK= part of the "Alter-Locale" command
(which
> can also be set in the sqr.ini file).
>
> > The error messages I get are:
> > Warning on line 16:
> >    (SQR 7501) Using YY edit mask from (DD-MON-YY) against (1998)
> > 20-NOV-98
>
> This is just a message to warn of a date conversion that's not y2k
> complient and can be turned off with the OutputTwoDigitYearWarningMsg
> setting in the Default-Settings section of the sqr.ini file.
>
> HTH,
>
-----------------------------------------------------------------------
> Donald Mellen  | Ray Ontko & Co. - Richmond, IN -
http://www.ontko.com/
> donm@ontko.com |  "In the beginning, there was nothing, which
exploded"
>

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com