Background documentation-1201: Too few columns Locate this document in the navigation structure

 

Explanation

In a referential CONSTRAINT definition, fewer referencing columns were specified than referenced columns. The number of specified columns in the referencing table must correspond to the number of referenced columns of the references table specified implicitly or explicitly.

User Response

Use a QUERY statement issued on the system table DOMAIN.COLUMNS to find out the current definition of the key columns in the referenced table. Use a QUERY statement issued on the system table DOMAIN.IND_USES_COL to find out the indexes of the referenced table. The specification of the referencing table columns must be adapted accordingly.