KFAA31280-E


      
         The SQL statement specification contains an error.

         
            
               aa....aa: Cause of the error

               
                  
                     
                        a column store table or a viewed table for which a column store table is specified in the outermost query in the viewed table definition, cannot be deleted, inserted, or updated

                        The following tables cannot be specified as target tables for deletion, insertion, or updating. <SQLSTATE: 42875>

                        
                           
                              Column store table

                           

                           
                              A viewed table that is defined by specifying a column store table in the outermost query specification

                           

                        

                     

                     
                        a table that defines the array-type columns cannot be deleted, inserted, or updated

                        The following tables cannot be specified as target tables for deletion, insertion, or updating. <SQLSTATE: 42875>

                        
                           
                              Table defining array-type columns

                           

                        

                     

                     
                        a LISTAGG set function cannot be specified in the window function

                        A LISTAGG set function cannot be specified in the window function. <SQLSTATE:42876>

                     

                     
                        an ARRAY_AGG set function cannot be specified in the window function

                        A ARRAY_AGG set function cannot be specified in the window function. <SQLSTATE:42877>

                     

                     
                        an array-type column cannot be specified as an external reference column

                        An array-type column cannot be specified as an external reference column. <SQLSTATE:42878>

                     

                     
                        rows cannot be deleted, inserted or updated using the cloud storage facility

                        When using the cloud storage facility, the INSERT, UPDATE, and DELETE statements cannot be executed. <SQLSTATE:42879>

                     

                     
                        the position of the "ORDER BY" clause specified in the subquery is invalid

                        A ORDER BY clause specified in the subquery is specified at an invalid location. <SQLSTATE:4287A>

                     

                     
                        the "LIMIT" clause must
                           be specified when the "ORDER BY" clause is
                           specified in the subquery or the with list element

                        If an ORDER BY clause is specified for a subquery or WITH list element, the LIMIT clause must also be specified. <SQLSTATE:4287B>

                     

                     
                        a struct-type column cannot be specified as an external reference column

                        A STRUCT-type column cannot
                           be specified as an external reference column. <SQLSTATE:4287C>

                     

                  

               

            
            
               S:

               
                  Ignores this SQL statement.

               

            
            
               Action:

               
                  Correct the SQL statement.