A fix is available
APAR status
Closed as program error.
Error description
PX Job using XML Reader does not respect the LANG environment variable. Server Job works correctly. This only happens when NLS is not installed. Client Business Impact: Customer has already developed PX jobs and encountered issues with the way the XML stage encode characters above char(127). Noted when using the British pound sign. The ワ sign is A3 in iso-8859-1 is encoded as C2A3 in UTF8. Action Taken: Confirmed that this issue only occurs with PX Jobs. It seems that when using XML stages with PX jobs, the data in the XML document are mapped to UTF-8, irrespective of LANG setting as documented in chapter 9 of the XML Pack Guide. Despite explicitly setting the LANG=en_AU.iso88591, which is the same encoding as the XML document input. --------------------------------------- Chapter 9. Local codepages on WebSphere DataStage servers --------------------------------------- Data is encoded using the local codepage of the WebSphere DataStage Server workstation when: o WebSphere DataStage Server runs in non-NLS mode. This applies to reading from an XML file and to writing to an XML file. o A file that resides on a WebSphere DataStage Server machine is accessed through a file path. This applies to both NLS modes. To ensure uniform and expected results when using the XML Pack, the local codepage of the WebSphere DataStage Server should be set for the locale that you want. Example of how to set the codepage for server: Method o Set the locale using the LANG environment variable. This variable is typically in the dsenv file. o To display the current locale, use the locale command. o To display a list of available locales (possible values for the LANG variable), use the following command: locale -a Example The locale is set to UTF-8: set LANG=en_US.UTF-8 Character data are interpreted as UTF-8 values. --------------------------------------- This isssue also happens on Information Server 8.0.1 and 8.1.
Local fix
Use XML Reader stage in a server job instead of a parallel job. This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: All 75x and 8.x users **************************************************************** PROBLEM DESCRIPTION: XML Stage not respecting local code page **************************************************************** RECOMMENDATION: Apply patch ****************************************************************
Problem conclusion
XML Stage not respecting local code page due to incorrect return value from DSCgetNLsOn
Temporary fix
Apply patch
Comments
APAR Information
APAR number
JR34482
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-10-13
Closed date
2010-05-17
Last modified date
2010-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 October 2021