Junction Record Represents Logical Child Segment
For each logical relationship that exists in the DL/I database, the logical child segment must be represented by a CA IDMS/DB junction record. For the junction to exist, there must be two CA IDMS/DB sets. Since there is no assurance that the load process has stored the two set owners (parent records) before it stores the junction (logical child) record, the set with the logical parent as owner must have a set connection option of OPTIONAL MANUAL.
After completing the load process, you can change the set's connection option to MANDATORY AUTOMATIC, if desired.
Bill-of-Materials Relationship Exception
The only exception is the bill-of-materials type of relationship, which requires the junction record to be owned by two different occurrences of the same record type. In this case, the set connection option must remain OPTIONAL MANUAL.
Use the Syntax Generator
It is recommended that you use the CA IDMS DLI Transparency syntax generator to produce a basic load schema with proper set connection options for logical relationships. See CA IDMS DLI Transparency Syntax Generator for a description of the GENERATE LOAD SCHEMA statement.
|
Copyright © 2013 CA.
All rights reserved.
|
|