Apply Operation Result Policy

Use the apply operation result policy to update the consolidated database (CDB) based on the returned result set of the called MBO operation.

The operation returns a record set that is processed and applied to the CDB.

This example uses the customer table from the sampledb database, which is accessible from the "My Sample Database" connection profile.

To create an MBO, drag and drop the sampledb customer table onto the Mobile Application Diagram. In the Quick Create wizard, accept the default operations.
In the Properties view, double-click the create operation to open the operation.

Select the Definition tab, and click Edit to update the SQL statement to:

INSERT INTO sampledb.dba.customer
(id,
fname,
lname,
address,
city,
state,
zip,
phone,
company_name)
VALUES
(@OP["id"=""],
'@OP["fname"=""]',
'@OP["lname"=""]',
'@OP["address"=""]',
'@OP["city"=""]',
'@OP["state"=""]',
'@OP["zip"=""]',
'@OP["phone"=""]',
'@OP["company_name"=""]'
)
SELECT * FROM customer where id = @OP["id"=""]

Select the Cache Update Policy tab, and select Apply operation result.
CDB and client data updates are based on the operation definition and the apply operation result policy; other enterprise information system (EIS) changes are ignored.