FTP Overwrite DS

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
jlockwo
Participant
Posts: 11
Joined: Tue Aug 17, 2004 12:51 pm

FTP Overwrite DS

Post by jlockwo »

How do I set up FTP to overwrite a dataset? I thought changing the Append to File property to NO would do this. When I try it, I get the following messages:

WARNING-
450 Data set LAYER.DETAIL.FINAL is allocated to another job and is unavailable for STOR command.

Followed by a FATAL-
Error while trying to open connection for sending data to the FTP server, FTP command STOR failed

Does anyone know why it won't overwrite the dataset? It works fine when the file does not exist. But after running once, it won't run again. The job finishes, so it isn't still writing to the file. I just don't know how to fix this. Hopefully someone will be able to help.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's usually a permissions issue - make sure your ftp user has what it needs to overwrite as well as create target files.
-craig

"You can never have too many knives" -- Logan Nine Fingers
jlockwo
Participant
Posts: 11
Joined: Tue Aug 17, 2004 12:51 pm

Post by jlockwo »

Thanks! We'll check that.
Post Reply