JR34364: DEFAULT TRIM STRING TRANSFORM FUNCTION GIVES DIFFERENT RESULTS WITH IS 8.1 WHEN COMPARED TO DS 7.5.2

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• Default Trim string function behaves differently with IS 8.1 NLS
  when compared to DS 7.5.2.
  

Local fix

• To change the coding to Trim( fld, " ", "R" ).
  
  This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All environments, users of IS 8.0.1 and IS 8.1
  ****************************************************************
  PROBLEM DESCRIPTION:
  The PX transform trimc_string and u_trimc_string functions were
  extensively modified for Hawk (IS 8.0) to correct discrepancies
  with the DataStage documentation (and the Server implementation
  of Trim) with respect to some nuances of whitespace handling.
  However, at least one customer (JP Morgan Chase) relied on the
  old 7.5x behavior of these functions.
  ****************************************************************
  RECOMMENDATION:
  Customers that need the trimc_string and u_trimc_string
  functions to treat whitespace as they did in PX 7.5x, should
  define the environment variable
  APT_TRIM_STRING_WHITESPACE_COMPATIBLE either on a project-wide
  or per-job basis.
  This fix is included in 81FP1
  ****************************************************************
  

Problem conclusion

• Added support for a new environment variable
  APT_TRIM_STRING_WHITESPACE_COMPATIBLE. When this variable is
  defined, the PX transform trimc_string and u_trimc_string
  functions will handle whitespace in the same way as their PX
  7.5x counterparts.  When the environment variable is not
  defined(default), it will handle whitespace in accordance with
  the DataStage documentation.
  

Temporary fix

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