Page 1 of 1
NLS not working in hash file
Posted: Fri Sep 02, 2005 3:52 am
by BradDriver
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?
Posted: Fri Sep 02, 2005 4:32 am
by Luk
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
Posted: Fri Sep 02, 2005 5:29 am
by BradDriver
It is using a DRS stage
Posted: Fri Sep 02, 2005 5:33 am
by Luk
DRS stage also using ODBC data source to get access to database!
Posted: Fri Sep 02, 2005 6:46 pm
by ray.wurlod
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.