KFAA31685-E

aa....aa cannot be specified. <SQLSTATE: 42IAB>

         
            
               aa....aa: Invalid option

               
                  
                     
                        BRANCH: BRANCH specification

                     

                     
                        COMPRESSION TYPE: Compression-type specification

                     

                     
                        CHUNK ARCHIVABLE: Chunk-archive specification

                     

                  

               

            
            
               bb....bb: Reason it cannot be specified

               
                  
                     
                        A data type is not VARCHAR or VARBINARY

                        The data type of the column is not VARCHAR or VARBINARY

                     

                     
                        The table option BRANCH ALL is specified

                        The table option BRANCH ALL is specified.

                     

                     
                        The table option STORAGE FORMAT COLUMN is specified

                        COLUMN is specified for the table option STORAGE FORMAT.

                     

                     
                        The table option STORAGE FORMAT COLUMN is not specified

                        COLUMN is not specified for the table option STORAGE FORMAT.

                     

                     
                        The table option BRANCH ALL was specified when the table was defined

                        The table option BRANCH ALL was specified when the table was defined.

                     

                     
                        The table is a column store table

                        The table is a column store table.

                     

                     
                        The table is a row store table

                        The table is a row store table.

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  Take corrective action as described in the following table:

                  

                        
                        
                        
                        
                           
                              
                                 Information output to bb....bb

                              

                              
                                 Description

                              

                              
                                 Action to take

                              

                           

                        

                        
                           
                              
                                 A data type is not VARCHAR or VARBINARY

                              

                              
                                 You cannot specify branch specification for a column whose data type is other than the VARCHAR type or the VARBINARY type.

                              

                              
                                 Use one of the following methods to correct the SQL statement:

                                 
                                    
                                       If you want to use a data type other than the VARCHAR type or the VARBINARY type for the column:

                                       Delete the branch specification from the SQL statement.

                                    

                                    
                                       If you want to specify branch specification:

                                       Change the data type of the column to the VARCHAR type or the VARBINARY type.

                                    

                                 

                              

                           

                           
                              
                                 The table option BRANCH ALL is specified

                              

                              
                                 You cannot specify branch specification for a table column that is defined by specifying the table option BRANCH ALL.

                              

                              
                                 Use one of the following methods to correct the SQL statement:

                                 
                                    
                                       If you want to specify the table option BRANCH ALL:

                                       Delete the branch specification from the SQL statement.

                                    

                                    
                                       If you want to specify branch specification:

                                       Delete the table option BRANCH ALL from the SQL statement.

                                    

                                 

                              

                           

                           
                              
                                 The table option STORAGE FORMAT COLUMN is specified

                              

                              
                                 You cannot specify branch specification for a table column that is defined with the table option STORAGE FORMAT COLUMN specified.

                              

                              
                                 Use one of the following methods to correct the SQL statement:

                                 
                                    
                                       If you want to define the table as a column store table:

                                       Delete the branch specification from the SQL statement.

                                    

                                    
                                       If you want to specify branch specification:

                                       Define the table as a row store table instead of a column store table:

                                    

                                 

                              

                           

                           
                              
                                 The table option STORAGE FORMAT COLUMN is not specified

                              

                              
                                 You cannot specify compression-type specification for a table column that is defined without the table option STORAGE FORMAT COLUMN specified.

                              

                              
                                 Use one of the following methods to correct the SQL statement:

                                 
                                    
                                       If you want to define the table as a row store table:

                                       Delete the compression-type specification from the SQL statement.

                                    

                                    
                                       If you want to specify compression-type specification for a column:

                                       Specify the table option STORAGE FORMAT COLUMN to define the table as a column store table.

                                    

                                 

                              

                           

                           
                              
                                 The table option BRANCH ALL was specified when the table was defined

                              

                              
                                 You cannot add a column for which branch specification is specified to a base table for which BRANCH ALL was specified when the table was defined.

                              

                              
                                 Delete the branch specification from the SQL statement.

                              

                           

                           
                              
                                 The table is a column store table

                              

                              
                                 You cannot add a column for which branch specification is specified to a column store table.

                              

                              
                                 Delete the branch specification from the SQL statement.

                              

                           

                           
                              
                                 You cannot specify chunk-archive specification for a column store table.

                              

                              
                                 A column store table cannot be changed to an archivable multi-chunk table by using the ALTER TABLE statement.

                                 If you need an archivable multi-chunk table, change the column store table to a row store table. For details about how to change a column store table to a row store table, see Changing a column store table to a row store table in the HADB Setup and Operation Guide.

                                 If you change the column store table to a row store table, specify chunk-archive specification when you execute the CREATE TABLE statement to define the table as an archivable multi-chunk table.

                              

                           

                           
                              
                                 The table is a row store table

                              

                              
                                 You cannot add a column for which compression-type specification is specified to a row store table.

                              

                              
                                 Delete the compression-type specification from the SQL statement.

Information output to bb....bb	Description	Action to take
`A data type is not VARCHAR or VARBINARY`	You cannot specify branch specification for a column whose data type is other than the `VARCHAR` type or the `VARBINARY` type.	Use one of the following methods to correct the SQL statement: If you want to use a data type other than the `VARCHAR` type or the `VARBINARY` type for the column: Delete the branch specification from the SQL statement. If you want to specify branch specification: Change the data type of the column to the `VARCHAR` type or the `VARBINARY` type.
`The table option BRANCH ALL is specified`	You cannot specify branch specification for a table column that is defined by specifying the table option `BRANCH ALL`.	Use one of the following methods to correct the SQL statement: If you want to specify the table option `BRANCH ALL`: Delete the branch specification from the SQL statement. If you want to specify branch specification: Delete the table option `BRANCH ALL` from the SQL statement.
`The table option STORAGE FORMAT COLUMN is specified`	You cannot specify branch specification for a table column that is defined with the table option `STORAGE FORMAT COLUMN` specified.	Use one of the following methods to correct the SQL statement: If you want to define the table as a column store table: Delete the branch specification from the SQL statement. If you want to specify branch specification: Define the table as a row store table instead of a column store table:
`The table option STORAGE FORMAT COLUMN is not specified`	You cannot specify compression-type specification for a table column that is defined without the table option `STORAGE FORMAT COLUMN` specified.	Use one of the following methods to correct the SQL statement: If you want to define the table as a row store table: Delete the compression-type specification from the SQL statement. If you want to specify compression-type specification for a column: Specify the table option `STORAGE FORMAT COLUMN` to define the table as a column store table.
`The table option BRANCH ALL was specified when the table was defined`	You cannot add a column for which branch specification is specified to a base table for which `BRANCH ALL` was specified when the table was defined.	Delete the branch specification from the SQL statement.
`The table is a column store table`	You cannot add a column for which branch specification is specified to a column store table.	Delete the branch specification from the SQL statement.
`The table is a column store table`	You cannot specify chunk-archive specification for a column store table.	A column store table cannot be changed to an archivable multi-chunk table by using the `ALTER TABLE` statement. If you need an archivable multi-chunk table, change the column store table to a row store table. For details about how to change a column store table to a row store table, see Changing a column store table to a row store table in the HADB Setup and Operation Guide. If you change the column store table to a row store table, specify chunk-archive specification when you execute the `CREATE TABLE` statement to define the table as an archivable multi-chunk table.
`The table is a row store table`	You cannot add a column for which compression-type specification is specified to a row store table.	Delete the compression-type specification from the SQL statement.