SQR 4.3.2 date problem

[Allen Wong <awong01@YAHOO.COM>]

All,

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

Here is a simple code I tried to execute:

-------------------------------------------------
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
begin-select
emplid
effdt
        show &effdt
from ps_job
end-select
end-procedure
-----------------------------------------------------

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.

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

Warning on line 16:
   (SQR 7501) Using YY edit mask from (DD-MON-YY) against (1998)
07-NOV-98
...

I have tested the same sqr on SQR 3.018 and it returns the expected
output of DD-MON-YYYY.

Can someone tell how to what is wrong with this thing.


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