Trouble with special characters using FTP Stage

ray.wurlod · Post by **ray.wurlod** » Wed Jun 14, 2006 3:26 pm

Can you select Unicode in the Extended column of the Columns grid? Does that help?

sud · Post by **sud** » Wed Jun 14, 2006 4:31 pm

ray.wurlod wrote:Can you select Unicode in the Extended column of the Columns grid? Does that help?

Hi,

I tried out the desribed scenario with the mentioned string and got this warning :

APT_CombinedOperatorController,0: Illegal character conversion found converting from UTF-8.

The problem is with all extended ascii characters. In my box, I am not getting the Unicode option in the extended column.

The funny thing is that, I tried to ftp the file from the same box to the same box in Unix and got the file in correct format. So, datastage is using UTF-8 and is doing the conversion. Is NLS needed to be installed and the NLS map has to be specified ?

kld05 · Post by **kld05** » Wed Jun 14, 2006 5:58 pm

Exactly. I tried a Unix to Unix ftp also prior to posting and got the correct result. The unicode option is also not an available for me in the extended column.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 14, 2006 6:36 pm

Sounds like your best approach is to run the FTP via an Execute Command activity (or a before-job subroutine ExecSH or ExecSHSilent) and process the local file, rather than to use the FTP stage.