Context Variable As Source SQL filter

_AnonymousUser — Sat, 03 Oct 2015 00:12:59 GMT

Hi,
I have a context variable PERIOD_YEAR and when I am using this variable in my source input SQL as below.
"SELECT C1,C2 FROM <ABC> WHERE PERIOD_YEAR = '"+context.PERIOD_YEAR"'"
when I am executing my ETL job, 'tOracleInput' object is throwing error as below
ERROR:
'java.sql.SQLSyntaxErrorExecution: ORA-01722: invalid number'
Please provide your input to resolve the issue.
Thanks
Saket Krishna

Re: Context Variable As Source SQL filter

Anonymous — Sat, 03 Oct 2015 01:07:42 GMT

You need to remove the single quotes from around the value held by the context variable. So instead of this....
"SELECT C1,C2 FROM <ABC> WHERE PERIOD_YEAR = '"+context.PERIOD_YEAR"'"
....try this....
"SELECT C1,C2 FROM <ABC> WHERE PERIOD_YEAR = "+context.PERIOD_YEAR

topic Context Variable As Source SQL filter in Talend Studio

Context Variable As Source SQL filter

Re: Context Variable As Source SQL filter