https://community.sap.com/t5/application-development-and-automation-discussions/merge-statement-in-bods-script/m-p/583720#M23241 <P>Hi </P> <P></P> <P>Iam using the below SQL call in a BODS script</P> <P></P> <P>SQL('DEV_DWH','MERGE INTO F_CLNDR TRG USING ( SELECT B.BUS_DAY,D.CLNDR_DT FROM (SELECT CLNDR_DT,BUS_DAY FROM F_CLNDR) B INNER JOIN (SELECT (CLNDR_DT-1) AS DTE,BUS_DAY,CLNDR_DT FROM F_CLNDR) D ON B.CLNDR_DT=D.DTE WHERE D.BUS_DAY IS NULL ) SRC ON (TRG.CLNDR_DT=SRC.CLNDR_DT) WHEN MATCHED THEN UPDATE SET TRG.BUS_DAY=SRC.BUS_DAY;');</P> <P></P> <P>Iam getting invalid character error while running this.Can you help me with this</P> Thu, 24 May 2018 17:42:34 GMT Former Member 2018-05-24T17:42:34Z https://community.sap.com/t5/application-development-and-automation-discussions/merge-statement-in-bods-script/m-p/583720#M23241 <P>Hi </P> <P></P> <P>Iam using the below SQL call in a BODS script</P> <P></P> <P>SQL('DEV_DWH','MERGE INTO F_CLNDR TRG USING ( SELECT B.BUS_DAY,D.CLNDR_DT FROM (SELECT CLNDR_DT,BUS_DAY FROM F_CLNDR) B INNER JOIN (SELECT (CLNDR_DT-1) AS DTE,BUS_DAY,CLNDR_DT FROM F_CLNDR) D ON B.CLNDR_DT=D.DTE WHERE D.BUS_DAY IS NULL ) SRC ON (TRG.CLNDR_DT=SRC.CLNDR_DT) WHEN MATCHED THEN UPDATE SET TRG.BUS_DAY=SRC.BUS_DAY;');</P> <P></P> <P>Iam getting invalid character error while running this.Can you help me with this</P> Thu, 24 May 2018 17:42:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/merge-statement-in-bods-script/m-p/583720#M23241 Former Member 2018-05-24T17:42:34Z