FTP Stage converting £ into other symbols

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

Post Reply
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

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 »

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 »

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 »

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 »

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!
Post Reply