PH28628: ITX SUBSTITUTE() FUNCTION REMOVING THE SPACE CHARACTERS FROM DATA WHEN ATTEMPTING TO REMOVE 0XFD AND 0XFE BYTE SEQUENCES

APAR status

• Closed as program error.

Error description

• This issue can be seen using any of the IBM Transformation
  Extender 9.0.0.x execution engines on any supported platform.
  
  The SUBSTITUTE() function is NOT working properly when it is
  used to remove certain bytes from the input byte stream, and
  only when those bytes are specified in a variable input file. In
  particular, it has been noted that there appears to be an issue
  with 0xFD and 0xFE bytes.  As a side-effect, it may be observed
  that all space characters (0x20) are removed from the input byte
  stream.
  
  It should be noted that hardcoding those bytes to be removed
  with the following will work:
  
  SUBSTITUTE(Input,"<<FD>>","","<<FE>>","")
  

Local fix

• ITXCQ - ITX00060512
  PB / CNB
  Circumvention: Do not read the 0xFD and 0xFE bytes from a
  variable input file, and instead hard-code those two bytes, if
  they need to be substituted.
  

Problem summary

• Users Affected:
  IBM Transformation Extender users who are using the Substitute
  function
  
  Problem Description:
  SUBSTITUTE function removing the space characters from the input
  file.
  
  Platforms Affected:
  All
  

Problem conclusion

• Handled the case of removing the spaces in Substitute function
  when 0xFD and 0XFE characters are present.
  
  Applies to:
  9.0.0.4, 10.0.0.0, 10.0.3.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the IBM Transformation Extender Release Notes page:
  https://www.ibm.com/support/docview.wss?uid=swg27008337
  
  If the service pack or product release is available, download it
  from Fix Central:
  http://www.ibm.com/support/fixcentral/
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a case:
  https://www.ibm.com/mysupport/
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

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

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels