Re: brio sqr vs ps sqr?

[Nathan Stratton Treadway <nathant@ONTKO.COM>]

On Tue, Jul 31, 2001 at 01:38:18PM -0700, Clara Carter wrote:
> I am wondering what the difference is between
> brio sqr and peoplesoft sqr? Can someone give me

The versions of SQR that PeopleSoft delivers are also available directly
from Brio; they are just "normal" versions of SQR.  (However, Brio often
releases new versions of SQR faster than PeopleSoft will officially
support them, so sometimes PeopleSoft's versions can best be described
as "normal but a little outdated" :). )


> a small explanation. and is class really necessary
> if you have sqr experience already? if so, where

If you are already familiar with SQR, you'll definitely be able to
understand PeopleSoft SQR programs without any additional classes.
On the other hand, PeopleSoft does have a whole "environment" built up
which you won't see in most non-PS SQR programs.  For example,
  * the mechanism for calling the SQR from the Process Scheduler
    (and the implications this has for generating different output
    types, etc.)
  * the proper way to update the job status from your SQR so it shows
    in the Process Scheduler
  * all the functions made available in the SQCs
  * to proper way to select from effective-dated tables

You may not need to attend a class just to learn about those, but you'll
at least want to spend a little time familiarizing yourself with these
sorts of topics.

                                                Nathan

----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/