FTP from Unix db2 server to another unix server

[cristi22]

Please help newbee in unix!

There is a task which runs on the DB2 via the task center:
task:

connect to ali user ali using ali;
export to   "/sanbasys/basysload/MEMBER.IXF" of IXF  select * from MEMBER; 
export to .....
connect reset;

I need to create a unix shell to:

(1) ftp MEMBER.IXF and other files to another server (masys)
(2) if ftp transfer return code = 0 then delete files from DB2 server.
(3) send e-mail with "task successful" message

someting like this:
cd bin

vi ftp_file:

#!/bin/ksh
machine masys login masys  password masys
lcd "home/BK_DIR"
put member.ixf member.ixf

if ftp=0 then
 rm member from ali
end

mail "taks is good"
rm member*

end 
good buy

THANKS A LOT FOR YOUR HELP!

 

[columb]

There are a number of issues here. The first, and most serious is that ftp returns 0 on successful completion whether or not the files were actually transferred.

If at all posible I urge you to look at ssh and the associated scp and sftp. Then the script becomes very simple

#!/bin/ksh
scp /home/BK_DIR/member.ixf user@remote_host:/remote/path && rm /home/BK_DIR/member.*

Otherwise the only method I know of guaranteeing that an ftp job has completed is to ftp the file back again under a different name and compare the returned file. In pseudo code

cd /home/BK_DIR
ftp othe_host
  put member.ixf member.ixf
  get member.ixf member.test
if diff member.ixf member.test == 0
  rm member.*

ftp can be coded using HERE scripts or .netrc scripts. Both have major security issues.

Ceci n'est pas une signature
Columb Healy