IBM Support

PK77464: When in VAG compatibility mode, a SQL singlerow select is not po pulating the EGL variables when it receives a -811 SQL code

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When developing programs in Rational Business Developer v7.1.0.1
    and VAG compatibility mode is enabled, an SQL singlerow select
    is not populating the EGL variables when it receives a -811 SQL
    return code.
    

Local fix

Problem summary

  • The problem is that the application is actually getting a
    SQL error back (code=-811 state=21000) meaning that the
    single row select statement actually produces more than 1
    row and DB2 issues an error in this event. Even though there
    is an error from DB2, it seems that DB2 still populates the
    SQL host variables with the 1st row's data.
    
    The difference between VAG and EGl, is that VAG actually
    used the VAG variables as the SQL host variables and when
    this SQL call was issued, the VAG variables got updated
    despite the error. With EGL, the SQL host variables are
    temporary variables that are not the EGL variables. EGL
    would then check the SQL error code and only move in the
    values to the EGL variables, if there was no error. Because
    of that, those EGL variables did not change.
    
    A fix has been made to check for this specific error code
    when using a single row select is made, and if detected, the
    move of the SQL host variable still takes place, and then
    the error is issued. This will only happen with in VAG
    compatibility mode.
    

Problem conclusion

  • Software updated
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK77464

  • Reported component name

    RATL BUS DEV

  • Reported component ID

    5724S5000

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-12-12

  • 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

    RATL BUS DEV

  • Fixed component ID

    5724S5000

Applicable component levels

  • R700 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.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
20 March 2009