MVSFORUMS.com

pwh · Beginner Joined: 06 Feb 2003 Posts: 2 Topics: 1

Hi All,

Can anyone please explain me in detail about the logic to identify the order of tables (by their parent -child relationship) in a tablespace?.

I am in need of this for deleting/loading a particular row in a table so that all other dependant rows are also deleted/loaded in the respective tables, in that particular order in whihc the relationship is maintained.

Thanks.

kolusu · Posted: Thu Feb 06, 2003 12:52 am Post subject:

Pwh,

Check this links for detailed explanation of

Defining relationships with referential constraints

Referential integrity and referential constraints

Hope this helps...

cheers

kolusu

pwh · Beginner Joined: 06 Feb 2003 Posts: 2 Topics: 1

Thanks Kolusu. I have gone thru the material. But it says about the measures to be considered before designing a database structure w.r.to referential integrity.

But I am in need of some info to identify the tables in which order I should go for deleting a row (along with its rows related in other tables as well) from the already exisiting database. Also, all my tables are defined with the DELETERULE as RESTRICT. could you please explain some logic on this?

Thanks.

Glenn · Beginner Joined: 23 Mar 2003 Posts: 56 Topics: 3

Basically you need to start doing some research to find out this information. My guess is there aren't any ER diagrams around in shop...this means you need to start looking at the tables which participate in the database, try to find common things and attempt to piece together an ER diagram from the table definitions you see and then research the programs and try to confirm it...

Like in a class enrollment system if I see the tables STUDENT, CLASS, and INSTRUCTOR I can make certain guesses about their relationships - the primary keys should be defined in the tables, so you shouldn't need to have much difficulty finding that...then go from there....you should be able to know about this system enough to be able to at least piece this together with maybe some help of your coworkers....

gotluru · Beginner Joined: 17 Dec 2002 Posts: 29 Topics: 6

If you have Platinum tool then RC/Query will help you to see Parent/Child Relationships between the Tables

Bithead · Posted: Mon Mar 24, 2003 4:03 pm Post subject:

Catalog table SYSIBM.SYSRELS is a good place to start.