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


Chapter 4 Processing Data : Delete Processing

Delete Processing
A DELETE request against an IDM table deletes the lowest-level member record in the access path providing that record does not have any member records. Records that have an OBTAIN OWNER directive are not deleted.
Processing Considerations
The following two methods can be used to delete records, providing the record to be deleted does not have any members:
Access the record occurrence you want to delete by issuing a GET or FORALL statement, and then issue a DELETE. Only the last member record defined in the access path is deleted. The definition can be parameterized or non-parameterized and can contain any number of records.
Issue a DELETE statement specifying the TIBCO Object Service Broker primary key value under the following conditions:
If the IDM table is non-parameterized, the definition can contain only one record. If the element selected as the TIBCO Object Service Broker primary key is not unique, the first record containing the value specified for the primary key is deleted.
If the IDM table is parameterized, the definition can contain only the parameterized record and one member record. If the element selected as the primary key is not unique within the set, the first record containing the value specified for the primary key, within the specified set, is deleted.

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