Re: [sqr-users] RE: Difference between SQR Process and SQR report

[cedric.jozon@accord.finances.gouv.fr]

Hello,
I use SQR_Process and SQR_Report in my job.
Because,  SQR_Process is better if you just have to handle data without 
any report.
Neither as the SQR_Report who can be use for printing Report and API.
In fact you can distribut Report to one Server and Process to an Other.


Cédric JOZON





"White, Denise" <DEWhite@vicr.com> 
Envoyé par : 
sqr-users-bounces+cedric.jozon=accord.finances.gouv.fr@sqrug.org
12/08/2004 15:51
Veuillez répondre à
"This list is for discussion about the SQR database reporting   language 
from Hyperion Solutions." <sqr-users@sqrug.org>


A
"SQR Users Group (E-mail)" <sqr-users@sqrug.org>
cc

Objet
[sqr-users] RE: Difference between SQR Process and SQR report






I don't see any reason to use SQR Process either.  I thought that's what I 
said.  Sorry if I wasn't clear.  I use SQR Report for all SQR jobs I 
develop.

Denise M. White
Sr. Software Engineer
HR/Payroll Systems
Vicor Corporation
----------------------------------------------------------------------

Message: 1
Date: Wed, 11 Aug 2004 08:00:44 -0500
From: David Ward <wardd@mail.uww.edu>
Subject: [sqr-users] Re: sqr-users Digest, Vol 6, Issue 8
To: sqr-users@sqrug.org

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:
>
>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>
>
>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

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