KFAA30744-E


      
         A foreign key cannot be defined for one of the following reasons: <SQLSTATE: 42I55>

         
            
               The referenced table specified is not a base table.

            

            
               The referenced table is the same as the referencing table.

            

         

         
            
               aa....aa: 

               
                  Foreign key schema name

               

            
            
               bb....bb: 

               
                  Foreign key constraint name

               

            
            
               cc....cc: 

               
                  Referenced table schema name

               

            
            
               dd....dd: 

               
                  Table identifier of the referenced table

               

            
            
               ee....ee: 

               
                  Cause of the error

               

            
            
               S: 

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

               

            
            
               Action:

               
                  The following explains how to handle this:

                  
                     
                        If the referenced table is not a real table is displayed for ee....ee

                        The referenced table specified is not a base table. Specify a base table for the referenced table.

                     

                     
                        If the referenced table is the same as the referencing table is displayed for ee....ee

                        The referenced table is the same as the referencing table. Foreign keys cannot be defined using the same referenced table and referencing table, so correct or delete the referential constraint definition.