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 number
IT24158
Reported component name
INTEGRATION BUS
Reported component ID
5724J0540
Reported release
A00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-02-22
Closed date
2018-06-12
Last modified date
2018-06-13
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
13 June 2018