IBM Support

PH14111: DATA ELEMENT UPDATED VIA CURSOR FETCH NOT CONSIDERED UPDATED BY THE CURSOR'S COLUMNS WHEN USING THE PROPRIETARY SCANNER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This was reproduced using v6.0.0.10, with the below code:
    
    
    EXEC SQL
    FETCH PRICE_TABLE
    INTO :START-DATE, :END-DATE,
    :PRICE
    END-EXEC
    
    So, the data element PRICE is used in the FETCH statement to
    receive the value from PRICE_MASTER.PRICE.  When you run an
    impact analysis on the column PRICE_MASTER.PRICE, the PRICE data
    element isn't considered impacted.   You can see from the data
    element details page that it's only considered to be referenced,
    not read from or written to.
    

Local fix

  • n.a
    

Problem summary

  • Data element updated via cursor FETCH not considered updated by
    the cursor's columns when using the proprietary scanner.
    

Problem conclusion

  • Updated the proprietary scanner so that a FETCH statement will
    include columns from the cursor, and replace any structure or
    array reference with child items or array references for each
    select list column.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH14111

  • Reported component name

    RATL ASSET ANAL

  • Reported component ID

    5724V2700

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-07-03

  • Closed date

    2019-07-03

  • Last modified date

    2019-07-03

  • 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 ASSET ANAL

  • Fixed component ID

    5724V2700

Applicable component levels

  • R610 PSY

       UP

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

Document Information

Modified date:
15 October 2021