DSXchange

JPM_SQL_OPTION5=where to_char(PAY_END_DT,'YYYY') in ('2006','2007')

when i try to pass to restrict all rows to some,the job gets aborted showing error like the year was not declared properly,and displaying year with out quotes where to_char(PAY_END_DT,YYYY) in (2006,2007),in log the single quotes not getting displayed.

That's not value SQL syntax: should be: Are you trying to pass in the WHERE clause as a job parameter called JPM_SQL_OPTIONS? I suggest you use proper notation.