Re: [sqr-users] SQR Unix env. variable setting

[Ray Ontko <rayo@ontko.com>]

Robert, Nelson,

Unfortunately this won't work.  When you do a call system, 
a new environment is created that disappears when the call
system completes.  So, although you can set the environment
variable in the new environment, it doesn't do anythign to
the context in which SQR is runing.  

With LET you can do a GETENV, but you can't do a SETENV.

Ray

On Thu, Apr 17, 2003 at 12:51:07PM -0400, Robert K. Foster wrote:
> Nelson,
> 
> I've not tried this but "call system using" is the sqr command you are
> probably looking for. However, since the sqr report would already be
> running/executing when you call the system with "set WHATEVER" to change
> the environment variable, you may still have a problem.
> 
> We had a situation where it was necessary to test out the latest version
> of Brio/SQR with a new set of client libraries from Sybase. The method I
> used was the previously suggested shell script which allows you to
> control every aspect of the unix environment before executing the sqr
> program itself. That way the older versions of everything stay in place
> and the shell script sets up other parameters(the new libraries) for the
> sqr execution. I used a standard bourne shell executed from the command
> line but you can easily run that using crontab or likely even the
> Peoplesoft whatever(which I have no experience with).
> 
> Hope that helps.
> Bob.
> 
> sqr-users-request@sqrug.org wrote:
> > Subject:            RE: [sqr-users] SQR Unix env. variable setting
> >      Date:            Wed, 16 Apr 2003 17:47:29 -0400
> >     From:            desello_nelson@jpmorgan.com
> > 
> > I already did that pssqr.unx on the Unix side its called.
> > But no luck.  Since the developer only run this particular sqr once a
> > month, I figured let's put in that sqr, but how?
> > 
> > Thanks,
> > Nelson
> 
> ===
> Bob Foster
> I/S Coordinator
> Mid-Michigan MRI, Inc.
> Direct Line: (517) 364-2673
> mailto:rkf@radiology.msu.edu
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

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