11.JPG

<div>
foreign keys can only reference primary keys or unique indexes,<br />
so if you want your foreign key to be on cid, you need to create a unique index on cid
</div>


foreign keys can only reference primary keys or unique indexes,
so if you want your foreign key to be on cid, you need to create a unique index on cid

<div>
<br />
Both of the above comments should help you solve your immediate problem.<br />
<br />
But, from a design standpoint, you may want to investigate whether there two table should be rolled up into one table. Obviously, I don't know the full background of what you're trying to accomplish, but it appears that the creationTime attribute more likely belongs in the parent table (complaints).<br />
<br />
HTH,<br />
DaveSlash<br />

</div>



Both of the above comments should help you solve your immediate problem.

But, from a design standpoint, you may want to investigate whether there two table should be rolled up into one table. Obviously, I don't know the full background of what you're trying to accomplish, but it appears that the creationTime attribute more likely belongs in the parent table (complaints).

HTH,
DaveSlash


<div>
<div class="content wysiwyg-content">
hi<br />
&nbsp; &nbsp; &nbsp; &nbsp; i have a table called complaints<br />
<br />
complaints(uid ,cid,subject description) where uid and cid are composite primary key<br />
<br />
and another table called <br />
<br />
complaints_access(uid,cid,<wbr /> creationtime)where again &nbsp;uid and cid are composite primary key<br />
<br />
where cid of complaints_access refers to cid of cid of complaints(foreign key).<br />
<br />
<br />
now it shows the following error<br />
<br />
SQL0573N &nbsp;A column list specified in the references clause of constraint <br />
&quot;CID...&quot; does not identify a unique constraint of the parent table<br />
<br />
<br />
please help!
</div>
</div>


hi
        i have a table called complaints

complaints(uid ,cid,subject description) where uid and cid are composite primary key

and another table called 

complaints_access(uid,cid, creationtime)where again  uid and cid are composite primary key

where cid of complaints_access refers to cid of cid of complaints(foreign key).


now it shows the following error

SQL0573N  A column list specified in the references clause of constraint 
"CID..." does not identify a unique constraint of the parent table


please help!

Foreign key problem in DB2 database

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.