IT24158: POSITION AND TRIM FUNCTIONS BROKEN ON USING "USEICUSTRINGMANIPULATION"

APAR status

• Closed as program error.

Error description

• Some of the POSITION and TRIM functions are broken when using
  the flag "useICUStringManipulation = yes" on ESQLManager.
  .
  For example the following TRIM and POSITION generates wrong
  output :
  .
  trim('A')='' instead of 'A'
  trim('A ')='' instead of 'A'
  trim('A ')='' instead of 'A'
  .
  POSITION('0' IN '0123456789')=0 instead of 1
  POSITION('0' IN '00123456789')=2 instead of 1
  
  
  Additional Symptom(s) Search Keyword(s):TRIM, POSITION,
  useICUStringManipulation, ESQLManager
  

Local fix

• Yes for POSITION
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All the users of IBM Integration Bus version 10 using ESQL
  functions TRIM and POSITION.
  
  
  Platforms affected:
  z/OS, MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  ESQL string functions TRIM and POSITION are broken when using a
  mode where ICU string functions are used.
  The mode is disabled by default, but can be enabled by running:
  mqsichangeproperties IB10NODE -e default -o ImbESQLManager -n
  useICUStringManipulation -v yes
  
  For example the following TRIM and POSITION generates wrong
  output  when useICUStringManipulation is enabled.
  .
  trim('A')='' instead of 'A'
  trim('A ')='' instead of 'A'
  trim('A  ')='' instead of 'A'
  .
  POSITION('0' IN '0123456789')=0 instead of 1
  POSITION('0' IN '00123456789')=2 instead of 1
  

Problem conclusion

• The product has been corrected so that the ESQL String functions
  TRIM and POSITION produce correct result on using the flag
  "useICUStringManipulation = yes" on ESQLManager.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.13
  v11.0      11.0.0.1
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  INTEGRATION BUS

• Fixed component ID

  5724J0540

Applicable component levels