Job Parameter removing quotes
Posted: Sat Jun 11, 2011 7:11 am
Hi...
I have a simple job like the following.
ODBC Stage ---------> Transformer ---------> Dataset.
In odbc, I am using a sql with an "IN" statement where in I want to give comma separted values. This comma separated values I want to give as a job parameter.
select X,Y,Z from TABA where state in ('A','B','C')
Even though I pass 'A','B','C' in the job parameter, datastage automatically remove that and the SQL is running with 'A,B,C'. Why it is automatically removing that? How to prevent or any alternative method to pass my desired value there.
Please request to help me here.
I have a simple job like the following.
ODBC Stage ---------> Transformer ---------> Dataset.
In odbc, I am using a sql with an "IN" statement where in I want to give comma separted values. This comma separated values I want to give as a job parameter.
select X,Y,Z from TABA where state in ('A','B','C')
Even though I pass 'A','B','C' in the job parameter, datastage automatically remove that and the SQL is running with 'A,B,C'. Why it is automatically removing that? How to prevent or any alternative method to pass my desired value there.
Please request to help me here.