NLS not working in hash file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Wed May 19, 2004 3:40 am
NLS not working in hash file
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.