datastage error

ravipuli · Post by **ravipuli** » Thu Jul 12, 2012 8:22 am

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

chulett · Post by **chulett** » Thu Jul 12, 2012 8:34 am

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

ravipuli · Post by **ravipuli** » Thu Jul 12, 2012 8:40 am

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

ravipuli · Post by **ravipuli** » Thu Jul 12, 2012 8:52 am

Hai craig can u reply me plz

ArndW · Post by **ArndW** » Thu Jul 12, 2012 9:02 am

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.