IBM Support

PM82786: SQL statements with INTO items generation warning

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Environment: Windows
    Product name: IBM? Rational? Business Developer
    Program Version    : 8.5
    Description.
    SQL statements (Open and GetByKey) which do not have computable
    INTO items at present give unhelpful output in problems view as
    there is no warning indicating to developers the actual cause of
    the error so they can address it.
    
    This defect will be addressed by providing a generation time
    warning on SQL statements including INTO clauses which are
    incorrectly formatted
    

Local fix

Problem summary

  • Previously, when a column from the select clause could not be
    matched with an item from the sql record (target of the Open or
    GetByKey statement), there was no indication that a problem may
    exist.
    

Problem conclusion

  • A generation time warning message has been added to warn the
    user that an INTO item was not found and that there may be a
    runtime problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM82786

  • Reported component name

    RATL BUS DEV

  • Reported component ID

    5724S5000

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-14

  • Closed date

    2013-10-28

  • Last modified date

    2013-10-28

  • 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

  • R850 PSY

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

Document Information

Modified date:
28 October 2013