JR39937: MULTI CHARACTER DELIMITERs ARE NOT WORKING IN PARALLEL TRANSFORMER FIELD() FUNCTION

IBM InfoSphere Information Server, Version 8.5 Fix Pack 2

APAR status

• Closed as program error.

Error description

• Delimiter containing multiple characters such as " " is not
  being interpreted correctly by field function. Only the first
  character is being used as the delimiter.
  

Local fix

• count the length of the delimiter, and subtract by one.
  Truncate the left side of the returned string by the length of
  the above value for any records greater than 1.
  

Problem summary

• In Information Server 8.5 jobs with transformer stages,
  if the customer use the field() function (aka
  substring_by_delimiter()) with a multicharacter delimiter for
  any field greater than 1.  For example, in the following string:
  
  "abc" "d""e" "fg" "gdfgh" "Cetin Approved"
  
  Using a parameter of '" "'  (' ' is the enclosed parameter, " "
  is the 3 character double quote, space, double quote parameter)
  -- if you chose a field of 1, the result will be correct:  "abc
  
  If you chose a field of 2, the expected result would be d""e (d,
  double quote, double quote, e).  Actual result is  "d""e
  (space, double quote, d, double quote, double quote, e).
  

Problem conclusion

• The internal template function was updated -
  substring_by_delimiter - to handle the multicharacter fields.
  

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

• R850 PSY

     UP