Deleting File After FTP

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I'm not sure about the wisdom of actually *deleting* the source file, we do the archive/compress thing, but to each his own.

An after-job routine, typically a script, that takes the filename as a parameter and does the delete should work fine for you. Make sure you tick off the 'only do this if the job completes successfully' option. [:D]

-craig
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

Write a script on the DataStage server that does an rsh into the Europe server and deletes the file. Call this script in an after job routine.

You could also write a before job script that does an rsh to the Europe server, compresses the source file, ftps it and uncompresses it on the DataStage server. Depending on your network this could save time and network traffic.



Vincent McBurney
Data Integration Services
www.intramatix.com
Post Reply