Page 1 of 1

Posted: Mon Dec 17, 2007 8:38 am
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?

Posted: Mon Dec 17, 2007 9:00 am
by rager
Hi,
Yes I have tried binary. It is giving the same problem. We are using Sun OS 5.8

Posted: Mon Dec 17, 2007 9:10 am
by rager
Hi,
Yes I have tried binary. It is giving the same problem. We are using Sun OS 5.8

Posted: Mon Dec 17, 2007 9:26 am
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!

Posted: Mon Dec 17, 2007 9:28 am
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!