Re: Upward Compatibility of SQR Versions

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

Denise...
I don't have the complete URL but if you head over to www.ontko.com you'll find a chart that shows the various commands over the all the versions of SQR.
Hope this helps,
Sam

<<< "White, Denise" <DWHITE@SYSTEMS.TEXTRON.COM>  7/ 2  9:37a >>>
I'm hoping someone can save us some time in our upgrade testing by either
assuring me of upward compatibility between versions 3 and 4, or pointing me
towards potential trouble spots.

We currently are running SQR 3.0.18.1.1.  We are an Oracle shop, and have
two systems that use SQR - PeopleSoft HRMS, and a non-PeopleSoft ERP system
(Point.Man).  Our ERP system is so heavily customized that a decision has
been made to never upgrade it (I'd like to state that I support HRMS and not
ERP!).  We need to upgrade PeopleSoft to Tools 7.05.10 and HRMS 7.02.  This
involves an upgrade to SQR 4.3.2.  Our DBA strongly feels that he wants only
one version of SQR running for both systems.  He plans to do some testing of
the ERP SQRs, but he assumes that any SQR written in version 2 or 3 will run
successfully in version 4.  I have heard at a PeopleSoft User Group meeting
that it is extremely important to thoroughly test every SQR program, which
leads me to believe there may be some incompatibilities.  Can anyone shed
some light on this issue?

One thing I have heard is that in SQR 4, you cannot do "alter session set
nls_date_format = 'DD-MON-YYYY';".  Unfortunately, I have just recently
modified most of my SQRs to use this, after having found that my date math
was not working correctly and was not including century in the calculations
(another interesting decision had been made here to leave the Oracle default
at DD-MON-YY and just program around it for Y2K compliance)!  This had
seemed by far the easiest solution - how do I do it in SQR 4?

Thanks in advance!
Denise White
Sr IT Application Developer
Textron Systems