Hi Wendel,
You need to change either your SQR code format mask to DD-MM-YYYY or change your SQR.INI file. The section you need to change is "OutputTwoDigitYearWarningsMsg = FALSE".
I think this solves this error.
Thanks
Venkat
-----Original Message-----
From: Wendel, Robbi [mailto:rwendel@NESPOWER.COM]
Sent: Monday, September 13, 1999 10:29 AM
To: Multiple recipients of list SQR-USERS
Subject: Tools upgrade SQR 3 to SQR 4 problems
We are starting our Tools conversion from 7.01 to 7.05 which
includes the SQR upgrade(3.0.18.1. to 4.3.4). Our database is Oracle 7.3.4
In our initial testing of our custom SQR's we are running into this warning
Warning on line 250:
(SQR 7501) Using YY edit mask from (DD-MON-YY) against (1999)
Where at the same time we seem to be having successful execution of ALTER
SESSION
showing the four digit year being set to YYYY(see below)
Cursor #1:
SQL = ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY'
Compiles = 1
Executes = 1
Rows = 0
These same SQR's run fine in the old version. What else do we need to
change?
Any thoughts would be appreciated!
TIA,
Robbi Anne Wendel
SCT Corporation
rwendel@nespower.com
(615) 747-3078