Skip to content

Instantly share code, notes, and snippets.

@tkMageztik

tkMageztik/MERGE_DB2_AS400

Created October 20, 2016 19:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tkMageztik/c2aae5f7338460106b7e6928b452c6c4 to your computer and use it in GitHub Desktop.
Save tkMageztik/c2aae5f7338460106b7e6928b452c6c4 to your computer and use it in GitHub Desktop.
Download ZIP
UPDATE INNER JOIN MEDIANTE MERGE
Raw
MERGE_DB2_AS400
MERGE INTO BFPCYFILES.CUMST A
USING (SELECT * FROM libjuarui.CUMST_b ) B
ON A.CUSCUN = B.CUSCUN
WHEN MATCHED
THEN
UPDATE
SET
A.CUSNA1 = B.CUSNA1,
A.CUSSHN = B.CUSSHN,
A.CUSLN1 = B.CUSLN1,
A.CUSFNA = B.CUSFNA,
A.CUSLN2 = B.CUSLN2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment