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

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



Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Asset Analyzer

Software version:

6.0

Reference #:

PM74109

Modified date:

2012-11-05

Translate my page

Machine Translation

Content navigation