[sqr-users] Using 'Call System' from a PeopleSoft SQR to delete a file

["Burns, Lawrence" <LABURNS@NYCT.com>]

Gentlemen:

I am using PeopleSoft 8, and I am trying to make my SQR delete a .txt file
on our Unix box, after my SQR (which is also on the Unix box) finishes
processing it, but I can't make it happen, either in 2-tier mode or thru the
browser.  Here's the code:

Let $InputFilePath = $OHSDirectory || rtrim($InputFilePath, ' ' )  the
filename is passed in from the page
Let #Status = 0
Let $Del = 'rm ' || $InputFilePath
call System Using $Del #Status wait
If #Status <> 0
 Show 'Command = ' $Del
 Show 'ERROR:  Cannot delete input file ' $InputFilePath '. Status = '
#Status 
End-If

And I keep getting an error:

>From trace file:
Cannot delete input file eis09/eis8batch/hupg/datain/current/ohs/lead3.txt.
Status = 2.000000 

>From message log:
rm: /eis09/eis8batch/hupg/datain/current/ohs/lead3.txt not removed.
Permission denied PeopleTools 8 - PSSQR Copyright (c) 1988-2001
PeopleSoft, Inc. All Rights Reserved Database Type: Oracle Database Name:
HUPG 
Report Name: NYOHLDLB Process Instance: 330602 Run Control ID: reports

I can't see why I can't delete the file, because here are the permissions:
-rwxrwxrwx   1 ps8upg     users         4307 May  7 11:30 lead3.txt 

I have also tried the delete function, but this doesn't work for me either,
I get . #Ret_Cd = 13.000000.

I am able to delete a .txt file off my Unix box in PeopleSoft 7, though!

Any suggestions?  Thank you for your consideration.









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