Tab as Column Delimiter in FTP Stage

ray.wurlod · Post by **ray.wurlod** » Fri Apr 07, 2006 12:13 am

Try 009. If you read the documentation more completely, you will find that a three digit decimal number is treated as an ASCII code. You can also specify Unicode as a hexadecimal number.

vaby · Post by **vaby** » Fri Apr 07, 2006 12:25 am

Hi Ray,

I tried 009, but it still ends up with "0" as column delimiter in the output file. May be I miss something else?

Vladimir

MerrillLynch · Post by **MerrillLynch** » Tue Apr 25, 2006 11:52 am

If you have NLS enabled, version 7.1r1 has issues with FTP'ing a tab delimited file. Open a case with Ascential and they can send you a patch to fix the issue. I have experienced the exact issue and the patch took care of it. The key is NLS - when you open the case make sure you mention that NLS is involved.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 25, 2006 4:19 pm

Welcome aboard. :D
Thank you for that answer. Do you happen to have the ecase number?

MerrillLynch · Post by **MerrillLynch** » Wed Apr 26, 2006 7:47 am

Thanks Ray - Here is the eCase number I originally had: 416113.
Because it took so long for this to get figured out, I worked directly with Jay Nash to fix this. At first Ascential could not reproduce the issue at their site but it turns out that they were testing on a server that did not have NLS enabled - once they realized it was NLS that was causing the issue they sent me a new dsftp.dll that resolved the issue.

vaby · Post by **vaby** » Sun Jun 04, 2006 9:49 pm

For archives -- the patch MerrillLynch mentioned has been delivered under eCase 52622. And it's for AIX, not for Windows. Hopefully I will have a patch for Windows from Ascential soon.

vaby · Post by **vaby** » Mon Jul 17, 2006 12:19 am

A patch for Windows that was delivered by Ascential is ECASE 96969.