JR34482: PX JOB USING XML READER DOES NOT RESPECT THE LANG ENVIRONMENT VARIABLE AS DOCUMENTED WHEN NOT USING NLS.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

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 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