Setting SQR_DB_DATE_FORMAT

[Allan Geetter <geetter@MAIL.HARTFORD.EDU>]

INPUT DATE statement in text format:  DD-MON-YYYY.

SQR will accept a 2 character year but when program run and date is
being reformatted to YYYY, incorrect century appears - e.g. 01-JUL-99
entered, result is 01-JUL-2099.

Oracle database being used.

Running SQR VER 4.2.1

Program aborts with SQR 1944 - The date is not in the format specified
by SQR_DB_DATE_FORMAT or in one of the accepted formats.

Is the SQR_DB_DATE_FORMAT set in the server SQR.INI file and if so how
and where.

Any help would be greatly appreciated.

Allan Geetter
University of Hartford
E-Mail:geetter@mail.hartford.edu


--
Allan
Geetter
Phone: (860) 768-4889
Data Security Administrator                                    FAX:
(860) 768-4907
University of Hartford
E-Mail:geetter@mail.hartford.edu
Information Technology Services - CC125
200 Bloomfield Avenue
West Hartford, CT 06117