DSXchange

In this case it works because the number string is implicitly converted to number format. Will the quoting work if you use "\'" instead of "'"? ... That i have tried but it gives error as Invalid charecter ,even view data is not possible but i like to confirm ,do u like to say like this e.g. job pa...

If it's VarChar ALL of the values in the IN list must be quoted in single quotes. ... that i know ,and that single quote is creating problem e.g. if we pass job parameter valuen as CUSTOMER_NUMBER IN ('01135101','01200662','ABCD') AND view data will show records , and when we run job 0 rows get sel...

Ok, I missed that. I thought the OP had used both in the SELECT statement and that the values (and syntax) didn't match. My firs thought is that the embedded single quotes in the parameter are not making it to the query correctly. Can you see the parameter value, with single quotes, in the Job Log?...

hi I am trying to pass Job parameter to Query in Odbc Enterprise stage e.g . SELECT Count(ID) As NUMBER_OF_REC FROM SDM_PLAN WHERE #jpTmpTestFilter# DAY >= to_date('31/12/2005','DD/MM/YYYY') And jpTmpTestFilter = CUSTOMER_NUMBER IN ('01135101','01200662') AND it select 0 rows ,But view data show all...