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