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 !
chulett wrote: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 wrote: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!
chulett wrote: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 ?