KFAA30613-E


      
         You cannot use the ALTER TABLE statement to add or delete a column. <SQLSTATE: 53021>

         
            
               aa....aa: Operation that resulted in an error

               
                  
                     
                        added to: Addition of a column by a ALTER TABLE statement

                     

                     
                        deleted from: Deletion of a column by a ALTER TABLE statement

                     

                  

               

            
            
               bb....bb: Reason why the column
                  cannot be added or deleted

               
                  
                     
                        A fix table in which data was stored at least once:

                        You cannot add or delete a column for a FIX table to which row storage segments have been allocated.

                     

                     
                        A table in which data has been stored at least once and for which BRANCH ALL option is specified:

                        You cannot add or delete a column for a base table for which BRANCH ALL is specified in the CREATE TABLE statement, and to which segments for storing rows are assigned

                     

                     
                        An archivable multi-chunk table:

                        You cannot delete columns for archivable multi-chunk tables.

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  Take one of the following corrective actions:

                  
                     
                        If aa....aa is added to

                        See When a column cannot be added to a base table in the HADB Setup and Operation Guide to add a column.

                     

                     
                        If aa....aa is deleted from

                        Take one of the following actions:

                        
                           
                              A fix table in which data was stored at least once

                              See Deleting a column after deleting all rows in a base table in Deleting columns of a base table in the manual HADB Setup and Operation Guide and delete the column.

                           

                           
                              A table in which data has been stored at least once and for which BRANCH ALL option is specified

                              See Deleting a column after deleting all rows in a base table in Deleting columns of a base table in the manual HADB Setup and Operation Guide and delete the column.

                           

                           
                              An archivable multi-chunk table

                              See Deleting a column in a archivable multi-chunk table in Deleting columns of a base table in the manual HADB Setup and Operation Guide and delete the column.