IBM Support

PK80396: Generated DDL has incorrect 'CREATE VIEW'

A fix is available

Rational Application Developer for WebSphere Software, Version 7.5.2

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A CREATE VIEW statement in DB2 i5/OS uses a FOR COLUMN clause to
assign 'System Name' to its columns.
In our product the System Name can be assigned using the Propert
ies View of the column.
The product incorrectly assigned Label instead of System Name to
 the columns.

Local fix

  • 



Problem summary


    

  • See Error Description.

    



Problem conclusion


    

  • The FOR COLUMN clause is followed by the System Name
assigned to the column. If no System Name is assigned, there
will be no such clause for that column.

Fix delivered in Rational Application Developer V7.5.2

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PK80396
    • 

  • Reported component name
    RATL APP DEV WI
    • 

  • Reported component ID
    5724J1901
    • 

  • Reported release
    700
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2009-02-10
    • 

  • Closed date
    2009-04-02
    • 

  • Last modified date
    2009-04-02
    • 





    

  • 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 APP DEV WI
    • 

  • Fixed component ID
    5724J1901
    • 



Applicable component levels


    

  • R700  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSRTLW","label":"Rational Application Developer for WebSphere Software"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 April 2009
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback