[sqr-users] Re: sqr-users Digest, Vol 6, Issue 8

[David Ward <wardd@mail.uww.edu>]

Denise -

We use 'SQR Report' exclusively.  I don't see any reason to used 'SQR 
Process' over 'SQR Report', but there are several reasons to use 'SQR 
Report'.  The main reason being that if you use 'SQR Process', the Process 
Scheduler will not pass the Operator Id or Run Control ID to the program, 
and things will not work properly.

Also, I've noticed that when using 'SQR Process', the API(application 
Program interface) stuff(ie. process instance, etc...) is not made 
available in the program.

David.





At 06:01 AM 8/11/2004 -0500, you wrote:
>Send sqr-users mailing list submissions to
>         sqr-users@sqrug.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
>         http://www.sqrug.org/mailman/listinfo/sqr-users
>or, via email, send a message with subject or body 'help' to
>         sqr-users-request@sqrug.org
>
>You can reach the person managing the list at
>         sqr-users-owner@sqrug.org
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of sqr-users digest..."
>Today's Topics:
>
>    1. RE: Difference between SQR Process and SQR report (White, Denise)
>
>From: "White, Denise" <DEWhite@vicr.com>
>Precedence: list
>Subject: [sqr-users] RE: Difference between SQR Process and SQR report
>Date: Tue, 10 Aug 2004 09:03:10 -0400
>To: "SQR Users Group (E-mail)" <sqr-users@sqrug.org>
>Reply-To: "This list is for discussion about the SQR database reporting
>         language from Hyperion Solutions." <sqr-users@sqrug.org>
>Message-ID: 
><3B835DA57619AF47B4FC6D1F94F357D1E7BBBF@25exch1.vicorpower.vicr.com>
>Content-Type: text/plain;
>         charset="iso-8859-1"
>MIME-Version: 1.0
>Message: 1
>
>What the Dragon says makes logical sense, but my advice would be to use 
>the SQR Report process type for any SQRs you develop, whether they produce 
>a report or just do updating.  I haven't delved into the details of why, 
>but using SQR Process usually ends in error; the parameters used are 
>different.  If you really want to know the difference, just examine the 
>process type definitions.
>
>(BTW, for those who don't know what this is about, it's PeopleSoft stuff)
>
>Denise M. White
>Sr. Software Engineer
>HR/Payroll Systems
>Vicor Corporation
>------------------------------
>
>Message: 3
>Date: Tue, 10 Aug 2004 05:34:28 -0500
>From: "the dragon" <ceprn@hotmail.com>
>Subject: RE: [sqr-users] Difference between SQR Process and SQR report
>To: sqr-users@sqrug.org
>Message-ID: <BAY12-F16xbYiMCIqtQ00001945@hotmail.com>
>Content-Type: text/plain; format=flowed
>
>I beleive an sqr process just does stuff in the database - DML, whereas an
>sqr report creates printed output.
>
>peace.
>clark 'the dragon' willis
>
>
>
>PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your
>services for 40 hours a week, not purchasing your soul.  Your time is the
>only real finite asset that you have, and once used it can never be
>recovered, so don't waste it by giving it away.
>
>"Time is the coin of your life. It is the only coin you have, and only you
>can determine how it will be spent.  Be careful lest you let other people
>spend it for you."
>
>Carl Sandburg
>(1878 - 1967)
>
>
>----Original Message Follows----
>
>Can anyone tell me the difference between SQR process and SQR report.?
>
>Syed Husain
>
>
>
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

David Ward
Technology & Information Resources
UW-Whitewater
800 W. Main St.
Whitewater, WI  53190
262-472-1039
Fax:     262-472-5733



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users