sequel error in ds

[just4u_sharath]

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.

[kcbland]

That's not value SQL syntax:

Code: Select all

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

should be:

Code: Select all

WHERE to_char(PAY_END_DT,'YYYY') in ('2006','2007') 

Are you trying to pass in the WHERE clause as a job parameter called JPM_SQL_OPTIONS? I suggest you use proper notation.