本地达梦数据库更新远程数据库数据

--create link "链接名" connect 'DPI' with"用户名" identified by"密码" using'IP:端口';
create or REPLACE link Link_DPI_1 CONNECT 'DPI' with "Test" IDENTIFIED BY "SYSDBA" using '1.1.1.1:5236';

update "TEST_BASE"."TABLE_TEST"@Link_DPI_1 A
join TEST_BASE.TABLE_TEST B on A.ID = B.ID
set A.SQL = B.SQL
where A.ID= 123