Cacher is the code snippet organizer for pro developers

MERGE INTO CES.XXXX a
USING TABLE( 
        VALUES('04827138','0','2010-1-1','2010-9-30','21090',10800200,'CM','N') 
)s(CUSTID,DUPNO,FINBDT,FINEDT,ACCTNO,AMT,CMPTYPE,RSVFLD) 
ON a.CUSTID=s.CUSTID and a.DUPNO=s.DUPNO and a.ACCTNO=s.ACCTNO and a.FINBDT=s.FINBDT and a.FINEDT=s.FINEDT 
WHEN MATCHED THEN 
	UPDATE SET AMT=s.AMT, CMPTYPE=s.CMPTYPE, RSVFLD=s.RSVFLD, TMESTAMP=current timestamp 
WHEN NOT MATCHED THEN 
INSERT (CUSTID,DUPNO,FINBDT,FINEDT,ACCTNO,AMT,CMPTYPE,RSVFLD,TMESTAMP) 
VALUES (s.CUSTID,s.DUPNO,s.FINBDT,s.FINEDT,s.ACCTNO,s.AMT,s.CMPTYPE,s.RSVFLD,current timestamp)