Re: Dynamic naming of the generated SQR.LOG file

[Steve Hall <srh@CONVOY.COM>]

Yeah. We do this all the time. Call SQR from some kind of scripting language
(VB, Perl, SQR) and have the calling program dynamically create the command
line. For example the log files could be named
like: -ox:\logdir\YYYY_MM_DD_HH_MM.LOG. There's lots of benefits to this
approach.

-----Original Message-----
From: Discussion of SQR, SQRIBE Technologies's database reporting
language [mailto:SQR-USERS@list.iex.net]On Behalf Of Anne-Marie Matula
Sent: Monday, May 10, 1999 6:22 AM
To: Multiple recipients of list SQR-USERS
Subject: Re: Dynamic naming of the generated SQR.LOG file


Are you using PeopleSoft?

In PS, I access the Process Scheduler - Use - Process Scheduler Definitions
panel and modify the SQR flag line to append a command telling the Process
Scheduler what log to write to.  Eg: -oc:\temp\uminqlod.log

I imagine you could also use a "Call System Using" command to rename the log
file within the Sqr.  However I haven't had a need to do anything like this.

Hope that helps
Anne-Marie


 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
Whitmore Bldg, University of Massachusetts, Amherst
Phone:  413/577-0685
Fax:    413/545-2150


>
>Date:    Fri, 7 May 1999 16:19:55 -0400
>From:    Bruce Weinstein <bruceweinstein@CANADA.COM>
>Subject: Dynamic naming of the generated SQR.LOG file
>
>I was wondering how you could dynamically change the name of
>the SQR.LOG
>file that is generated when
>you run the SQR.  Seeing as my output is going to this file
>and I would like
>to retain the output and that we run the SQR daily, is there a
>way to do it.
>
>I am currently using SQR 3.0.18.1.1
>
>        .B