IBM Support

PM74109: COLUMN NAME USED IN COBOL ORDER BY STATEMENT IS BEING INCORRECTLY ADDED AS A DB2 TABLE NAME IN RAA

Fixes are available

Rational Asset Analyzer 6.1
Rational Asset Analyzer for System z 6.1
Rational Asset Analyzer Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer for System z Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer for System z Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer for System z Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer for System z Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer for System z Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer for System z Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
Rational Asset Analyzer Fix Pack 23 (6.1.0.23) for 6.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Client uses Proprietary COBOL scanner to inventory COBOL code
    which contains SQL that has a statement that uses the ORDER BY
    syntax that specifies a column name.
    That column name is incorrectly being interpreted as a
    DB2 table name and added to the RAA inventory as such, although
    it is only visible in the DB2 Tables used by Program view, and
    not the DB2 Table Summary screen.
    

Local fix

  • none known
    

Problem summary

  • Correlation names of tables as qualifier of columns used in
    ORDER BY clause of SELECT INTO statement were not resolved.
    

Problem conclusion

  • The fix is to resolve the correlation names into table names
    and to output references to the columns in the ORDER BY clause.
    The fix affects clients with COBOL assets inventoried with the
    RAA
    Proprietary scanner who use SELECT INTO statements with order
    by clause containing column names qualified by correlations.
    To take advantage of the fix, once installed, clients must
    collect inventory again with post processing
    in order to resolve correlation names qualifying columns.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM74109

  • Reported component name

    RATL ASSET ANAL

  • Reported component ID

    5724V2700

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-01

  • Closed date

    2012-11-05

  • Last modified date

    2012-11-05

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • DMH0731
    cobscan
    

Fix information

  • Fixed component name

    RATL ASSET ANAL

  • Fixed component ID

    5724V2700

Applicable component levels

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

Document Information

Modified date:
29 October 2021