Hi,
I have a Main table with 7 Primary keys.
I also have a Child table which I want to relate it to Main table via Foreign keys.
Can I use the 6 Foreign keys in Child Table as reference to only the 6 primary keys instead of 7 to the Main Table.
When I am doing this I am getting Errors as:-

SQL State = 42890 SQL Code = -573 SQL Message = A column list specified in the references clause of constraint "FL_DESIG..." does not identify a unique constraint of the parent table or nickname "MBID.TMST". Exception message = com.ibm.db2.jcc.c.SqlException: A column list specified in the references clause of constraint "FLI_DESIG..." does not identify a unique constraint of the parent table or nickname "MBID.TMST".

one table can only keep 1 primary key
different foreign keys can point to the same pk
see
Designing primary key constraints

But I wanted those senev columns to uniquely define my rows.
And in the Child key a foreign key of six.

pratikp.vasani, I think what you mean is you have 1 Primary key consisting of 7 columns. You have another table where you want to create a RI rule based on 6 columns from the Child table to only 6 of the 7 columns in the Primary Key on the Parent table.

The answer is No, you can't do that. If you have 7 columns in the Primary Key, the the Foreign Key also has to have 7 columns.