Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Mon Dec 17, 2007 8:38 am
Have you tried specifying a binary transfer? If not, give that a go and see if it changes the behaviour. Also, which UNIX OS are you reading from?
rager
Participant
Posts: 27 Joined: Tue Jul 17, 2007 11:23 pm
Location: UK
Post
by rager » Mon Dec 17, 2007 9:00 am
Hi,
Yes I have tried binary. It is giving the same problem. We are using Sun OS 5.8
rager
Participant
Posts: 27 Joined: Tue Jul 17, 2007 11:23 pm
Location: UK
Post
by rager » Mon Dec 17, 2007 9:10 am
Hi,
Yes I have tried binary. It is giving the same problem. We are using Sun OS 5.8
rager
Participant
Posts: 27 Joined: Tue Jul 17, 2007 11:23 pm
Location: UK
Post
by rager » Mon Dec 17, 2007 9:26 am
I read somewhere that PX doesn't support Binary mode for FTP. The work around for this would be to define the columns as varbinary and then FTP then in ASCII mode.
Voila! It works!! Thanks for your pointer!
rager
Participant
Posts: 27 Joined: Tue Jul 17, 2007 11:23 pm
Location: UK
Post
by rager » Mon Dec 17, 2007 9:28 am
I read somewhere that PX doesn't support Binary mode for FTP. The work around for this would be to define the columns as varbinary and then FTP then in ASCII mode.
Voila! It works!! Thanks for your pointer!