KFAA30613-E

The ALTER TABLE statement cannot be used to add columns to the following types of tables: <SQLSTATE: 53021>

         
            
               A FIX table to which segments for storing rows are assigned

            

            
               A base table for which BRANCH ALL is specified in the CREATE TABLE statement, and to which segments for storing rows are assigned

            

         

         
            
               aa....aa: Reason why columns cannot be added

               
                  
                     
                        A fix table in which data was stored at least once: A FIX table to which segments for storing rows are assigned

                     

                     
                        A table in which data has been stored at least once and for which BRANCH ALL option is specified: A base table for which BRANCH ALL is specified in the CREATE TABLE statement, and to which segments for storing rows are assigned

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  For details about how to add columns to these tables, see When a column cannot be added to a base table in the HADB Setup and Operation Guide.