Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 4 Processing Data : Insert Processing

Insert Processing
An INSERT request always attempts to STORE a CA‑IDMS record. CA‑IDMS CONNECTs automatic owner records and the Gateway CONNECTs manual owner records included in the IDM table definition.
Processing Considerations
When an IDM table definition contains multiple CA‑IDMS records, excluding owner records with an OBTAIN OWNER directive, the number of records STOREd as a result of an INSERT is dependent on the number of elements (excluding FILLER elements) selected from each record. For example:
If a definition contains all elements from the OFFICE and EMPLOYEE records, the Gateway STOREs and CONNECTs both records.
If an IDM table definition contains a parameter on the OFFICE record and all elements of the EMPLOYEE record, the Gateway STOREs only the EMPLOYEE record, CONNECTed to the OFFICE record parameter value.
When an IDM table definition contains owner records with an OBTAIN OWNER directive, the result of an INSERT is:
The Gateway CONNECTs that member to the owner specified providing the specified owner record exists and is a CALC record
For a parameterized IDM table, the parameterized record is retrieved and all fully selected member records are STOREd and CONNECTed to the parameterized record when an INSERT is issued.
A CA‑IDMS error occurs if you do not include all automatic owner records of the member record to be inserted in your IDM table definition. Manual owner records included in the definition are explicitly CONNECTed to the member record you are inserting.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved