Updating Linked Progress Server from SQL Server

[BCM]

How can I pass SQL Update/Insert/Delete statements from SQL Server to a linked progress server so that the SQL executes on the remote Progress server and does not execute on the SQL Server?

 

[BCM]

Heres the answer:

Assume Linked Server Name: LinkedDB
Linked Server Properties
Check Yes for Collation Compatible
Check Yes for Data Access
Check Yes for RPC
Check Yes for RPC Out
Check Yes for Use Remote Collation

Assume we are subtracting one from the Quantity column of the Inventory table for part-no=1234.

UPDATE LinkedDB..PUB.Inventory
Set Quantity = OPENQUERY(LinkedDB, 'Select Quantity from PUB.Inventory where "Part-No" = 1234') - 1