JR41196: In parallel xform stage, using loop variables in a derivation with IF, SETNULL() FUNCTION CAUSES NULL FOR BOTH THEN AND ELSE

APAR status

• Closed as fixed if next.

Error description

• In a Transformer stage, there is a loop while @ITERATION <= 2,
  to create two output rows for each input row.
  There is also a loop variable that uses a SetNull() in its
  derivation: If @ITERATION = 1 Then SetNull() Else "Z"
  In the Output link the loop variable are used in the derivation
  of one of the columns.
  If SetNull() is used, then the output column is set to null for
  both output rows.
  But, we expect that the first row to have null, and the second
  row to have "Z".
  

Local fix

• If a dummy nullvalue is used, then we get the expected
  behaviour:
  Change the loop variable to use a dummy null value in its
  derivation: If @ITERATION = "NULLVALUE" Then SetNull() Else "Z"
  In the derivation of the Output column, check for the dummy null
  value: If @ITERATION = 2 Then "NULLVALUE" Else "Z
  

Problem summary

• In a Transformer stage, there is a loop while @ITERATION <= 2,
  to create two output rows for each input row.
  There is also a loop variable that uses a SetNull() in its
  derivation: If @ITERATION = 1 Then SetNull() Else "Z"
  In the Output link the loop variable are used in the derivation
  of one of the columns.
  If SetNull() is used, then the output column is set to null for
  both output rows.
  But, we expect that the first row to have null, and the second
  row to have "Z".
  

Problem conclusion

Temporary fix

• f a dummy nullvalue is used, then we get the expected
  behaviour:
  Change the loop variable to use a dummy null value in its
  derivation: If @ITERATION = "NULLVALUE" Then SetNull() Else "Z"
  In the derivation of the Output column, check for the dummy null
  value: If @ITERATION = 2 Then "NULLVALUE" Else "Z
  

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

Applicable component levels

• R850 PSN

     UP

• R870 PSN

     UP