IBM Support

PH14162: CORE - SQL COLUMN DECLARE_FLAG SET TO B WHEN IT SHOULD BE Y OR N

Direct links to fixes

readme
RAAInstall
RAAInstallRepository
RAAzInstall
RAAzInstallRepository
readme
RAAInstallRepository
RAAzInstall
RAAzInstallRepository
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

  • After scanning the program, the DB2 tab of the Program details
page and listed all the DB2 columns instead of the referenced
ones. It should only list the unreferenced ones if the Advanced
option to display them is chosen.

This problem appears to have been introduced when RAA quit using
 the C module to resolve dynamic references, when
common\dmhd494.sqc was ported to Java.

Local fix

  • n.a

Problem summary

  • DB2 tab of the Program details page lists columns with 0
references even when "Include unreferenced columns" is
unchecked.

Problem conclusion

  • Updated the product to correctly set DMH_SQL_COLUMN.DECLARE_FLAG
 with values N/Y/B, depending on how the column is used.

Temporary fix

  • n.a

Comments

  • 



APAR Information




    

  • APAR number
    PH14162
    • 

  • 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-04
    • 

  • Closed date
    2019-07-04
    • 

  • Last modified date
    2019-07-04
    • 





    

  • 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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback