PM78904: THE TONUMBER FUNCTION MAY RETURN A NULL IF THE FORMAT STRING IS DEFINED IN A DATA OBJECT INSTEAD OF AS A LITERAL

APAR status

• Closed as program error.

Error description

• The TONUMBER function may return a NULL if the Format String is
  defined in a data object instead of as a literal.
  
  For example, the following map rule uses the TONUMBER function
  with a Format String defined in a data object.
  
  =TONUMBER(InputString Fields:Output, FormatString Fields:Output)
  
  InputString Fields:Output = 999,99
  FormatString Fields:Output = "L-####[','##]"
  
  The TONUMBER function does not return any value.
  

Local fix

• WTXCQ - WTX00041965
  EJ / EJ
  Circumvention: None
  

Problem summary

• Users Affected:
  WebSphere Transformation Extender customers who use ToNumber
  with format strings in the data (as opposed to literals in the
  rules).
  
  Problem Description:
  A format string in data was not working properly in ToNumber.
  
  Platforms Affected:
  All
  

Problem conclusion

• The format string was not being NULL-terminated before it was
  sent to the format string conversion function, so it was
  considered invalid.  I added code to (temporarily)
  NULL-terminate it.
  
  Delivered in:
  8.3.0.6, 8.4.0.4
  

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

  WEBSPHERE DESIG

• Fixed component ID

  5724M4008

Applicable component levels

• R820 PSY

     UP

• R830 PSY

     UP

• R840 PSY

     UP