PK78767: RBD 7.1.0.1 SQL select clauses using same SQL field more than on ce in the same open are using the same host variables

APAR status

• Closed as program error.

Error description

• When SQL fields are associated with an internal host variable an
  d there is more than 1 occurrence of the same SQL field in an OP
  EN statement (for example - the second occurrence having an addi
  tional function call such as '- 1 DAY'), an EGL program could ex
  perience
  unexpected results due to a single host variable being used for
  both occurrences of the SQL field.  The result from the SQL call
   for the 2nd occurrence of the host variable could overwrite the
   value in the 1st variable's result.
  

Local fix

Problem summary

• The code that builds the into items was not handling the
  arithmetic expression correctly
  

Problem conclusion

• I have fixed the code to correctly process the arithmetic
  expression
  

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

  RBD EGL FOR COB

• Fixed component ID

  5724S5001

Applicable component levels

• R710 PSN

     UP