Re: Strange Behaviour

[Elvis Pressly <elvisdman@HOTMAIL.COM>]

When you upgraded SQR to 4.xx from 3.xx you have to use -ZIF argument
in the PSSQRFLAG of your configuration manager. You have to add this
also to your SQR.ini as well if it will fit (128 char limitation in
windows). See explanation below from Peoplesoft.

Note 2: If you were once using SQR version 3.x and have upgraded to SQR
version 4.x, and you do not include the "-ZIF" flag, then you will probably
not see an error. The reason for this is because version 4.x SQR will use
SQR.INI if it cannot find PSSQR.INI via the "-ZIF" flag.  However, SQR.INI
may not contain all the correct parameters that are needed for version 4.x
SQR. So, if the version 4.x SQR is being used, confirm it is being used in
conjunction with the "-ZIF" flag.

elvis


>From: srinivasan.seetharaman@DB.COM
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Strange Behaviour
>Date: Wed, 21 Feb 2001 19:20:46 +0530
>
>Hello All,
>      We had developed a SQR program . It was running well in Ver 3.x .
>When running the same in Ver 4.x we got the following error message.
>
>*************************************************************************
>Warning on line 51:
>    (SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)
>
>Warning on line 52:
>    (SQR 7501) Using YY edit mask from (DD-MON-YY) against (2001)
>(SQR 5528) ORACLE OFEN error 1841 in cursor 5:
>    ORA-01841: (full) year must be between -4713 and +9999, and not be 0
>
>Error on line 142:
>    (SQR 3725) Bad return fetching row from database.
>
>SQR: Program Aborting.
>*************************************************************************
>
>On noting , we found that there are couple of input parameters(date
>fields). From & Thru date(s). We also found that the field
>"native-date-format"  in
>  setenv.sqc has different values in 3.x & 4.x. In 3.x it contains
>YYYY-MM-DD HH:MI:SS while in 4.x it contains DD-MON-YYYY HH:MI:SS.
>
>Anyone knows why such a strange behaviour ?.
>
>
>Regards,
>
>   S.Srinivasan.
>______________________________________
>E-Mail : Srinivasan.Seetharaman@db.com
>______________________________________

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com