IBM Mainframe Forum

Is many to many relationship is possible in IDMs? Please can anybody explain this

Hello and welcome to the forum,

Well, yes. . . So far, i've not seen any database system that prevents many-many relationships.

Are you familiar with the many-many concept?

It is not clear what you want explained. If you show an example of what you are working with/looking for, someone may be able to post a more useful reply.

Thanks, In IDMS Set represent one to many relationship in the same way can set support many to many relationship, this question was asked to me in one of the interview.

In IDMS... Junction records are used to create many to many relationships.

For instance a many to many beteween recs TEACHER and STUDENT may be
created by using a junction record named TCHSTU

Each TEACHER rec would be connected to many TCHSTU recs ( a 1 to many )

Each STUDENT rec would be connected to many TCHSTU recs ( a 1 to many)

combined this construct creates a many to many

TEACHER------->TCHSTU<---------STUDENT

Hello and welcome to the forum,

Good to have a new IDMSer with us