NLS not working in hash file

BradDriver · Post by **BradDriver** » Fri Sep 02, 2005 3:52 am

We are running a job that moves data from one SQL Server database to another SQL Server database, performs a sum and then writes out a hash file. The Polish characters are written correctly on the 2 databases but not in the hash file. We are using NChar on all input and output tabs, locale is PL for Poland, default map for stages is UTF8. Any ideas?

Luk · Post by **Luk** » Fri Sep 02, 2005 4:32 am

what are you using to access to source and target?
na ODBC stage?

if yes, and your server is Microsoft SQL Server try to add proper code page option to your DNS source
i.e AppCodePage=1250

BradDriver · Post by **BradDriver** » Fri Sep 02, 2005 5:29 am

It is using a DRS stage

Luk · Post by **Luk** » Fri Sep 02, 2005 5:33 am

DRS stage also using ODBC data source to get access to database!

ray.wurlod · Post by **ray.wurlod** » Fri Sep 02, 2005 6:46 pm

The NLS map for DataStage Hashed Files must always be NONE.

This is because DataStage Hashed Files operate entirely within the DataStage environment; any characters needed are mapped on the boundaries between the external world and DataStage; remapping can only cause errors.

Of course, if you're accessing UniVerse or UniData hashed files, that is a different story; these are external to DataStage and therefore mapping would be required.