IBM Support

PM41798: SQL nullable indicators are erroneously being generated for the WHERE clause when generating on VSE systems

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Product name: IBM? Rational? Business Developer
    
    Program Version    :  7.5.1.6
    Description.
    SQL nullable indicators are erroneously being generated for the
    WHERE clause when generating on VSE systems after migrating from
    EGL v6 to RBD v7.5.x.
    
    Setting the isSQLNullable property to yes causes the WHERE
    clauses to also have the indicator variables added and causes
    performance issues with data access not seen in RBD v6. The same
    program generated to COBOL on the VSE with RBD 7.5.1.6 creates
    up to a 1 minute waiting time when data is retrieved from the
    DB2 tables which in V6 was almost instant.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The nullable indicator was being generating on the SQL where
    clause for VSE systems, when the user specified that
    sqlnullable = yes. It should have been ignored. This causes
    a performance hit to VSE sql systems.
    

Problem conclusion

  • The software now ignores the nullable indicator for
    variables in the where clause.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM41798

  • Reported component name

    RBD EGL FOR COB

  • Reported component ID

    5724S5001

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-16

  • Closed date

    2012-03-15

  • Last modified date

    2012-03-15

  • 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

  • R751 PSN

       UP

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

Document Information

Modified date:
27 October 2021