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

[Morris K Hicks <mkhicks@DUKE-ENERGY.COM>]

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.