FTP Complex file from one unix server to another

[ms294]

Does any one know if we can FTP Complex file from one unix server to another with Dastage 7.5 ? I cann't use FTP-Plug in stage as it only work on standard file format, I want know if Datastage can ftp whole file instead of write stream from one server to another. Thanks !

Mark

[shivajid2k]

You can write a script and call it in before/after routine

[DSguru2B]

Did you try doing the transfer as a single column within the ftp stage?

[ms294]

Did you try doing the transfer as a single column within the ftp stage? ...

Good ideal, I'll try this. thanks !

[chulett]

Make sure you tell it not to add anything to the file - quotes in particular.

[ms294]

Make sure you tell it not to add anything to the file - quotes in particular. ...

Right, I tries put 000 for delimiter and quote which mean nothing, but FTP stage abroted with error "not valid delimiter and quote". is there way to get out of this ?

[chulett]

Hmmm... while that works in the Sequential File stage, you may just need to leave it blank in the FTP stage.

[ms294]

Make sure you tell it not to add anything to the file - quotes in particular. ...

Right, I tries put 000 for delimiter and quote which mean nothing, but FTP stage abroted with error "not valid delimiter and quote". is there way to get out of this ?

I solve this by set "no line terminator and no quote", thanks!

[ms294]

Hmmm... while that works in the Sequential File stage, you may just need to leave it blank in the FTP stage. ...

Craig,

Do you have any experience with such process on Datastage 7.5 : I need check if flat file has empty records, if empty , no ftp sending, otherwise ftp send file to remote server. What stage may solve this file check ?

[ray.wurlod]

You can carry out these checks in the "telnet command" executed prior to the transfer.

[chulett]

Or perhaps via a Sequence job, it could do the check and then decide whether to run the FTP job or not. Really depends on where/when you can check.