Skip to content

Instantly share code, notes, and snippets.

@ahmednrana
Created December 18, 2019 21:50
Show Gist options
  • Save ahmednrana/63d10dcb50656aa931001d40cc5eaec2 to your computer and use it in GitHub Desktop.
Save ahmednrana/63d10dcb50656aa931001d40cc5eaec2 to your computer and use it in GitHub Desktop.
Maximo applicationauth from another table
MERGE INTO APPLICATIONAUTH TA
USING (SELECT GROUPNAME, APP, OPTIONNAME, CONDITIONNUM FROM APPLICATIONAUTH2) AS TB
ON (TA.GROUPNAME = TB.GROUPNAME AND TA.APP = TB.APP AND TA.OPTIONNAME = TB.OPTIONNAME AND TA.CONDITIONNUM = TB.CONDITIONNUM)
WHEN NOT MATCHED THEN
INSERT (APPLICATIONAUTHID, GROUPNAME, APP, OPTIONNAME, CONDITIONNUM)
VALUES (NEXTVAL FOR APPLICATIONAUTHSEQ, TB.GROUPNAME, TB.APP, TB.OPTIONNAME, TB.CONDITIONNUM);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment