JR44733: PARALLEL TRANSFORMER STAGE INCORRECTLY EVALUATES DERIVATIONS WHICH CONTAIN COMPLEX USAGE OF FUNCTIONS IN IF CONDITIONS

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• Column or stage variable derivations or constraints which have
  the below characteristics are evaluated incorrectly
  a. Functions uses in IF conditions
  b. These functions take more than 1 parameter
  c. These parameters are nullable columns or other functions
  or both nullable columns and other functions.
  
  Ex:
  if (DSLink1.ipcol1 = Substring(DSLink1.ipcol2, 1,DSLink1.len)
  if (Substring(trim(DSLink1.ipcol1)), DsLink1.len1, DSLink1.len2)
  = 'abc')
  
  The incorrect evaluation can cause rows to be sent to the
  incorrect output link.
  
  Note: For a constraint, we do not need an explicit IF
  condition. A constraint is always treated as an IF condition.
  

Local fix

• Evaluate the constraint in a stage variable and check the stage
  variable in the constraint.
  

Problem summary

• ERROR DESCRIPTION:
   Column or stage variable derivations or constraints which have
  the below characteristics are evaluated incorrectly
  a. Functions uses in IF conditions
  b. These functions take more than 1 parameter
  c. These parameters are nullable columns or other functions
  or both nullable columns and other functions.
  
  Ex:
  if (DSLink1.ipcol1 = Substring(DSLink1.ipcol2, 1,DSLink1.len)
  if (Substring(trim(DSLink1.ipcol1)), DsLink1.len1, DSLink1.len2)
  = 'abc')
  
  The incorrect evaluation can cause rows to be sent to the
  incorrect output link.
  
  Note: For a constraint, we do not need an explicit IF
  condition. A constraint is always treated as an IF condition.
  
  LOCAL FIX:
  Evaluate the constraint in a stage variabe and check the stage
  variable in the constraint.
  

Problem conclusion

• The patch for this APAR fixes the problem.
  

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

• R870 PSY

     UP

• R910 PSY

     UP