hi, im kinda new here and im using db2 v8.1.2.169, fixPak 2, on windows. My problem is that i have a Zoo entity with a foreign key not null referencing to the Primary Key of the Employee entity and a foreign key not null of Employee referencing to the Primary Key of the Zoo entity, i dont seem to be able to insert any data to the initial state of these 2 tables. my question is why and how do i do it.

~nick.

drop the relationship first.i mean drop one of the foreign key.then only you will able to insert data initially to both tables.....after insert reconstruct the relationship by altering the table whose foreign key was dropped.
....................anyways i don't understand purpose of such kind of design.(parent of each other)

Not to mention that in some states, such relationships are illegal.

Maybe the "employee" rows contain a reference to the department where they work, and the "department" rows contain a reference to their head-of-department (in the employee table).

exactly, that was the case. thx guys for the info.

~nick.