Deleting external file in FTP...

[Liangck]

Hi all,

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.

Regards

LiangCk.

[dhana]

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

Thanks

Dhanasekaran R

[Ksharp]

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.

Ksharp

[Liangck]

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"
     host=&ftpHost  
     user=&ftpUser pass=&ftpPass
     prompt;
%let rc = %sysfunc(fdelete(fileDel)); 

     Thanks anyway.Apperciate your help.

Regards:

Liangck