Skip to Content
0
May 24, 2018 at 05:42 PM

Merge Statement in BODS Script

161 Views

Hi

Iam using the below SQL call in a BODS script

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;');

Iam getting invalid character error while running this.Can you help me with this