DSXchange

i have filter stage in job here iam getting this below error
Filter_1: Parse error: Expected comparison operator ('>', '<', ...) after literal, got: <eof>.

can anybody help to solve this problem pls

Thaks,
ravi

How about starting by explaining to us what you have in properties of the stage?

this is the where clause in my filter


(CONTRACT_SUB_TYPE='VarianceIndexSwap' or CONTRACT_SUB_TYPE='VarianceBasketSwap' or CONTRACT_SUB_TYPE='VarianceShareSwap') and EQTY_SUBMISSION_ID=TMP_ACTIVE_SUB_ID and (TRANS_TYPE='Termination' or TRANS_TYPE='Novation' or TRANS_TYPE='Exercise-Callable')

Hai craig can u reply me plz

It looks OK at first reading. What if you removed the first "(" to ")" group and recompile/re-run; does the error go away? Are the column names correct? Continue to remove elements in the where clause until the error goes away.