[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] naming multiple reports



That might work, but I think I'll just stick with the default names. :) 


Thanks though.  

-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------
>>> steve.cavill@infoclarity.com.au 01/28/05 7:23 PM >>>
Yes that is a problem if the command line is too long.
Maybe you could modify the Process Scheduler SQR execution script to
rename
the .lis files after SQR has finished?
Steve.

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On
Behalf Of Jamie Harris
Sent: Saturday, 29 January 2005 9:13 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] naming multiple reports


What if you had multiple reports "open" at once and needed to be able to
use
the "use-report" command to go between them?

I have a report that produces a report of successes, a report of errors
and
a report of warnings.  Each row of data could potentially be one of the
three, so I can't simply process all of report 1's data then say
"new-report" to start the next one.

I haven't been able to find a way to do that without specifying with -f
all
the different names and the path to put them in (which results in a
command
line that's too long for the Peoplesoft process scheduler).

Any thoughts?


-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> jwomeldo@fastenal.com 1/28/2005 12:18 PM >>>
Use the New-Report command as described in this document:
http://www.ontko.com/sqr/sqrcard4.html 

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
Susan
Haberman
Sent: Friday, January 28, 2005 10:26 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] naming multiple reports


Hi,

I am trying to name multiple reports instead of using the default naming
convention  reportname_instance_#.lis

In the process scheduler manager>use>process definitions>override
options I
have tried several options:

1) Parameter List: Append -MR 5 -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis This sqr runs successfully but uses default
name.

2) Command Line: Append -MR 5 -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis and
    Command Line: Override -MR 5 -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis and
    Parameter List: Append -MR 5
    Command Line: Append -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis

These processes error with the following message: Process Request shows
status of 'INITIATED' or 'PROCESSING' but no longer running 

Has anyone successfully managed to rename the output files?  We are
running
Oracle on a Unix server.
Thanks for your help!


_______________________________________________
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

_______________________________________________
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


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