09-26-2011 11:12 PM
Suppose i have a senario that read external file from ftp and after reading it, i wish to made a deletion on that particular external file.
i tried FDELETE but seem it cant do so.
my colleage tell that fdelete function are only access to a local directory but not remote directory.
is there any other method to do so?
Seeking for help, thanks you. Apperciate its alot.
09-27-2011 02:07 AM
You can specify the delete command on the RCMD parameter of the filename statement.
FILENAME FILEREF FTP "ABC.DAT" HOST="TESTHOST" USER="USERNAME" PASS="PASSWORD" RCMD="DELE ABC.DAT";
otherwise you can try this also
QUOTE RCMD DLTF FILE(mylib/myfile)
mylib is the name of the library from which the file is to be deleted. myfile is the name of the file to be deleted.
Hope this helps...!
09-27-2011 02:13 AM
Firstly , make sure you have right to deleting files at ftp .
And also you can use OS command to delete it.
Start-> Run-> cmd-> ftp 10.1.2.2 -> del ....
Maybe it should be worked.
09-29-2011 12:05 AM
Hi DHNA and Ksharp
thanks for your advice, i done it with fdelete alreadly..
the code like this
filename fileDel ftp "&&SAS_Import&&Note&I&&Data_Upload&&Docm&J"
%let rc = %sysfunc(fdelete(fileDel));
Thanks anyway.Apperciate your help.