Bookshelf v7.7: About the Execute Method

The Execute method can be specified on EAI Siebel Adapter to perform combinations of various operations on components in an integration object instance. This method uses the following operations:

These operations perform the same tasks as the related methods. For example, the delete operation makes the EAI Siebel Adapter delete the business component record matched to the particular integration component instance. However, what will be done to the children depends on the combination of the parent operation and the child operation. For details, see Table 12.

Operations that include the word sync in the name cause deletion of unmatched child records, whereas update, insert, and upsert do not delete any children. Table 11 presents the overview of the six related operations.

Table 11. EAI Siebel Adapter Execute Method Operations
EAI Siebel Adapter Action	upsert	sync	update	updatesync	insert	insertsync
Error on Match Found	No	No	No	No	Yes	Yes
Error on Match Not Found	No	No	Yes	Yes	No	No
Delete Unmatched Children	No	Yes	No	Yes	No	Yes

NOTE: You should use the Execute method when you need to mix different operations on different components within a single integration object; otherwise, you should use the other methods.

An XML document sent to a Siebel application can include operations that describe whether a particular data element needs to be inserted, updated, deleted, synchronized, and so on. These operations can be specified as an attribute at the component level. They cannot be specified for any other element.

About Execute Method Operations

Specify an attribute named operation, in lowercase, to the component's XML element. The legal values for this attribute are upsert, sync, delete, query, update, insert, updatesync, insertsync, and none. If the operation is not specified on the root component, the sync operation is used as the default.

NOTE: Specifying operation within <ListOf> tag is not supported. For details on the <ListOf> tag, see XML Reference: Siebel eBusiness Application Integration Volume V.

Supported Operations for the Parent and Its Child Components

Table 12 presents the operation performed for a child component based on its parent component's operation and its own operation.

Table 12. Supported Operations
		Parent Operation
		query	query page	sync	upsert	update	update sync	insert	insert sync	delete
Child Operation	query	query	query	upsert	upsert	update	update	insert	insert	delete
	query page	query	query	upsert	upsert	update	update	insert	insert	delete
	sync	query	query	sync	sync	sync	sync	sync	sync	delete
	upsert	query	query	upsert	upsert	upsert	upsert	upsert	upsert	delete
	update	query	query	update	update	update	update	upsert	upsert	delete
	update sync	query	query	update sync	update sync	update sync	update sync	sync	sync	delete
	insert	query	query	insert	insert	insert	insert	insert	insert	delete
	insert sync	query	query	insert sync	insert sync	insert sync	insert sync	insert sync	insert sync	delete
	delete	query	query	delete	delete	delete	delete	delete	delete	delete