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?
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
