Re: PeopleSoft placing output in /var/tmp

[Brian Murray <Brian.C.Murray@VANDERBILT.EDU>]

Apologies in advance to non-PeopleSoft users.

I've been out a few days, sorry if this has already been answered.  In
PeopleSoft, you can easily direct the output of SQR's that generate
listing in the "normal" methods: i.e. those whose destinations you
specify with the -f option on the SQR command line.  However, there are
a number of PeopleSoft SQR programs which generate files, not listings,
and the name and/or location of the file is set in the program itself.
Typically, these SQR's use the substitution variable FILEPREFIX to set
the directory name.  This FILEPREFIX is set in the setenv.sqc and for
UNIX (in a vanilla install) is defined as /usr/tmp.  In some UNIX
flavors, /usr/tmp is a link/alias for /var/tmp.

I would suggest a quick scan of the offending SQR (ccltrgen) to see
where it is setting up the file name for your letters file.  I suspect
you will find it uses FILEPREFIX.  If you don't like /usr/tmp then you
have a couple of options:
1. Modify setenv.sqc.  Unfortunately this is a global setting for ALL
sqr's which use this sqc and you will not be able to set this value
dynamically (e.g. different settings for test and production) without
creating separate sqc's.
2. Modify the SQR and put in your own file naming logic.  We've taken
this approach a couple of times.  We set some UNIX environment variables
and use the SQR's getenv function so that we can set the directory
dynamically.



--
Brian Murray                      Brian.C.Murray@vanderbilt.edu
Office of Administrative Systems
Vanderbilt University