[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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