IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    PK78767

  • Reported component name

    RBD EGL FOR COB

  • Reported component ID

    5724S5001

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-15

  • Closed date

    2009-03-20

  • Last modified date

    2009-03-20

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
20 March 2009