KFAA31271-E


      
         The column definitions of the foreign table aa....aa specified in the
            CREATE VIEW statement differ between when the view table was
            defined and when the view table was retrieved. <SQLSTATE:
            4275D>

         
            
               aa....aa:

               
                  Name of the foreign table

               

            
            
               bb....bb:

               
                  Name of the column or field that caused the error

               

            
            
               S:

               
                  Ignores this SQL statement. Alternatively, the system invalidates this
                     transaction.

               

            
            
               Action:

               
                  The column definition of the column or field bb....bb
                     differs between when the view table was defined and when the view table was
                     searched. One of the following is different.

                  
                     
                        Name

                     

                     
                        Data type

                     

                     
                        Data length

                     

                     
                        Maximum number of elements

                     

                     
                        Number of columns

                     

                     
                        Number of fields

                     

                  

                  Recreate the view table, which uses the foreign table
                     aa....aa as its underlying table, in
                     ascending view level order using the ALTER VIEW
                     statement or similar. For details about the ALTER VIEW statement, see ALTER TABLE (alter table
                     definition) in the manual HADB SQL Reference.

                  Note that this message may be output when retrieving a view table that meets
                     all of the following conditions.

                  
                     
                        A view table is defined using a
                           foreign table that has a STRUCT type column as its underlying table in
                           HADB server version 06-00.

                     

                     
                        The HADB server has been upgraded to version 06-01 or later.