Disconnecting a record from a set

[Anon Anon]

Good day All, I have a owner record that is associated or linked to a child record and I would like to disconnect a specific set, with a spefic key which is known. The child record that must be deleted is also known. How do I disconnect? can I use DMLO or do it in a Cobol program?  Thanks in advance.

[Tommy Petersen]

If the child record is to be deleted, you can just delete it, no need to disconnect first, just get currency on the child record and delete it.

 

[Chris Hoelscher]

In fact – depending upon how the set relationship is defined, deleting the child row may be the ONLY optional (it may not be possible to dis-associate the child from the parent row)

Chris hoelscher
Technology Architect | Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:image001.png@01CD13D7.1A57CAF0]
123 East Main Street |Louisville, KY 40202
[e-mail]
Humana.com
[phone] – office
[phone] - blackberry
Keeping CAS and Metavance safe for all HUMANAty

From: CA IDMS IUA EIUA Global User CommunityMessage Boards [mailto:[e-mail]]
Sent: Thursday, February 06, 2014 9:34 AM
To: [e-mail]
Subject: [Application Developer Issues] RE: Disconnecting a record from a set


If the child record is to be deleted, you can just delete it, no need to disconnect first, just get currency on the child record and delete it.


Posted by:tommy.petersen
--
CA Communities Message Boards
108889831
[e-mail]<mailto:[e-mail]>
https://communities.ca.com

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

[Gary Cherlet]

There are some database design issues to consider. If your dilemna is that the member record ( M let's say) participates as a member in a number of sets - then you may not want to ERASE it? If that's the case - then you will want to DISCONNECT M from just the one set - you must ensure that it is an optional member. If M is a mandatory member you can only remove M with an ERASE!

Knowing the "key" of the member record of a set is useful if it is a sorted set - in which case you can do OBTAIN member-record within set-name using sort-key-value. If it is not a sorted set then you must use iterative OBTAIN next member-record within set-name statements to locate the desired record using comparison statements to identify the desired record's "key".

HTH - cheers - GaryC