Hi I am using a query as below:
BEGIN NOT ATOMIC
FOR temp_row AS SELECT pr.REC_TRK_ID,c m.FINC_MTCH_KEY _ID,pr.MED_MTCH _KEY_ID FROM CARDTC.PGM_REQ pr LEFT OUTER JOIN CARDTC.CDB_MTCH cm ON pr.MED_MTCH_KEY _ID=cm.MED_MTCH _KEY_ID WHERE pr.SRC_SYS_ID=' CES' AND pr.STS_CD IN('N1','H1')
DO
IF FINC_MTCH_KEY_I D IS NOT NULL THEN
#If TASK
ELSE
#Else TSK
END FOR;
END,...