[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] RE: Difference between SQR Process and SQR report
- Subject: [sqr-users] RE: Difference between SQR Process and SQR report
- From: "White, Denise" <DEWhite@vicr.com>
- Date: Thu, 12 Aug 2004 09:51:12 -0400
- Delivery-date: Thu, 12 Aug 2004 08:54:22 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcSAcn8tvseO/PX8SDihLN9l9lAYYg==
- Thread-topic: 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