Re: SQR 2905 - Can't Open file 'OUT1' as 1. Permission Denied-Reply -Reply

[Mark Kraft <kraftm@GUNET.GEORGETOWN.EDU>]

ok then,
what we have done here is used the {FilePrefix} and {FileSuffix} from
the SETENV.SQC, however, the sqc is stored in each instance that we
have on both the fileserver and Unix box.  The {fileprefix} is dynamically
set to the instance that we are working in.  As well as this, we have
batch files setup (run my pressing a shortcut key from Windows) that
set up the instance parms in PeopleSoft.  There are seperate UNIX
scripts in each instance as well.  So..... when we run the SQR's that
have to write flat files, the fileprefix is set to the instance we run in and
set to run in a place that we have read / write access to.  In short, check
the SETENV.SQC, set the {FILEPREFIX} on the Client to C:\TEMP, put the
SQC in the MAINFRAME and have it point somewhere else.
(Our UNIX guy did all of this, so this is as detailed as I can get)  Hope this
helps some more

Mark Kraft
kraftm@gunet.geogetown.edu

>>> Morris K Hicks <mkhicks@DUKE-ENERGY.COM> 11/16/98 03:25pm
>>>
Mark,
That works when running on the Client (and that is in fact what I had
done
as a work-around) but this will not work on the mainframe.  We like to
keep
our client and mainframe copies identical so that we are not having to
always
convert when uploading the client SQR program to the mainframe.





Mark Kraft <kraftm@GUNET.GEORGETOWN.EDU> on 11/16/98 03:02:15
PM

Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Morris K Hicks/Corp/DukePower)
Subject:  SQR 2905 - Can't Open file 'OUT1' as 1. Permission Denied
-Reply




you can do something like this:

   let $filename = 'Test.dat'
   let $file = C:\TEMP\'   || $filename
   open $file as {out} for-writing record=80 status = #stat_read

Try this, I have used it for a long time and always worked for me

Mark Kraft
kraftm@gunet.georgetown.edu


>>> Morris K Hicks <mkhicks@DUKE-ENERGY.COM> 11/16/98 02:52pm
>>>
We are using PeopleSoft 6.0 Financials on Windows NT,  IBM/DB2.
SQR version 3.
I have an SQR that utilizes the following statement:
OPEN $OUT1 AS 1 FOR-WRITING RECORD=138:FIXED

The report ran fine for weeks, then one day they changed the
permissions
to one of our LAN directors, L:.   The problem is that this OUT1 file is
saved
on the L:\FS600\BIN directory, and now that I do not have access to
write
to this directory, the SQR bombs.

This isn't an issue when run on the mainframe, but when run on the
client
I get the Can't Open File error.  Is there a way within PeopleSoft to
change
the default directory from L: to the C: drive, where it probably should
have
been from the beginning?  I would have thought this setting could be
made
in Config Manager, but I only see one reference to L:\FS600\BIN there,
and
I can't change that because that is for PeopleTools executables.