KFAA31128-E


      
         A FULL OUTER JOIN specification has one of the following errors.

         
            
               The table defining the array-type column specified for the table reference in FULL OUTER JOIN or the specified location of that array-type column is incorrect. For details, see Rules in Specification format and rules for joined tables in the manual HADB SQL Reference. <SQLSTATE:427I1>

            

            
               A FULL OUTER JOIN table reference specification has one of the following errors. For details, see Rules in Specification format and rules for joined tables in the manual HADB SQL Reference. <SQLSTATE:427I2>

               
                  
                     A table reference on both sides of a FULL OUTER JOIN specifies a table in which all columns are array-type columns or STRUCT type columns.

                  

                  
                     When a table that defines an array-type column or STRUCT type column for a table reference on either side of a FULL OUTER JOIN, the array-type column or STRUCT type column is specified in an other item than the ON search condition of the FULL OUTER JOIN.

                  

               

            

            
               An external reference column whose reference destination is a table reference specified in FULL OUTER JOIN was specified. For details, see Common rules for subqueries in Rules in Specification format and rules for subqueries in the manual HADB SQL Reference. <SQLSTATE:427I8>

            

         

         
            
               aa....aa: Cause of the error

               
                  
                     
                        array-type column: Incorrect position specified for array-type column

                     

                     
                        correlated subqueries: An external reference column was specified.

                     

                     
                        array-type or struct-type column: Incorrect position specified for array-type column or STRUCT type column

                     

                  

               

            
            
               bb....bb: Error detail message

               
                  
                     
                        There is an error in the table that defines the array-type column specified in the table reference of FULL OUTER JOIN, or the specified position of the array type column is invalid:

                        Table defining the array type specified in the table reference of FULL OUTER JOIN, or the specified position of that array-type column.

                     

                     
                        The column which refers to "Table Reference" in "FULL OUTER JOIN":

                        Column referencing a table reference specified in FULL OUTER JOIN

                     

                     
                        There is an error in the table that defines the array-type or struct-type column specified in the table reference of FULL OUTER JOIN, or the specified position of the array type or struct-type column is invalid: 

                        Table defining the array type or STRUCT type specified in the table reference of FULL OUTER JOIN, or the specified position of that array-type column or STRUCT type column.

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  Correct the SQL statement.