Sftp ing the files and deleting files on remote server.

[venkat_april]

Hi all ,

After SFTP'ing the source files successfully to the local server , how to delete files from the remote server ? Any inputs greatly appreciated.

Thanks in advance.

rsh -l USER <SERVER> find <TOP LEVEL DIR> -atime <2years> -exec rm -r {} \;

[kollurianu]

You will need to talk with your UNIX administrator. It seems that either "rsh" is not installed or not in your path, likewise will most likely be the case for "ssh" as well. Once you sort out getting this command working (with or without adding userid/password) then you can implement it into DataStage.

Thanks for your response , Could you please send me exact syntax to be used in command stage (in a job sequencer)?

Any inputs greatly appreciated.

[chulett]

As noted, talk to your UNIX Admins. Once they help you get it working from the command line outside of DataStage, you'll know what the exact syntax is you'll need for the Sequence job.