Search found 2 matches

by puneeth
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...
by puneeth
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...