Re: [sqr-users] Using 'Call System' from a PeopleSoft SQR todelete a file

["Prasanna Menta" <pmenta@umuc.edu>]

Is the file being used by the same sqr program? if so is there a Close 
explicitly specified ?
Prasanna
----- Original Message -----
From: "Burns, Lawrence" <LABURNS@NYCT.com>
Date: Friday, June 6, 2003 9:12 pm
Subject: [sqr-users] Using 'Call System' from a PeopleSoft SQR to 
delete a file

> 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
> 

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