Search found 2 matches
- Thu May 23, 2019 1:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS issues in DataStage with WIN-1252 characters
- Replies: 3
- Views: 5621
NLS issues in DataStage with WIN-1252 characters
Thanks for your suggestion. I tried the below options, but none of them worked: 1) Changing NLS Settings at job level to windows-1252 or ASCL_MS1252. 2) Tried Loading a file and Peek stage. WIN-1252 characters are still being displayed as character "?" in the file and job log. 3) Added Uni...
- Tue May 21, 2019 2:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS issues in DataStage with WIN-1252 characters
- Replies: 3
- Views: 5621
NLS issues in DataStage with WIN-1252 characters
Windows character set encoding MS1252 ( 0x80 to 0x9F) that is not compatible with ISO-8859-1 is causing problems when reading from Windows MSSQL Server into datastage and loading Netezza. In this case, the character is "Right Single Quotation Mark". Specifically , when reading from Datasta...