topic Re: sql query on interger context variable in Talend Studio

sql query on interger context variable

Anonymous — Sat, 16 Nov 2024 08:49:56 GMT

I want to write a condition with two where condition on Context integer value on tOracleInput

Select order_num from order_table

where id >= context.a1

and id<= context.a2;

Where a1 and a1 and id are all integer value.How to achieve that in tOracleInput.

Re: sql query on interger context variable

TRF — Fri, 19 Jan 2018 19:19:29 GMT

Try this for the condition:

"id >= " + context.a1 + " and id<= " + context.a2

Hope this helps.

Re: sql query on interger context variable

Anonymous — Fri, 19 Jan 2018 19:39:08 GMT

I tried that before :I get this error:
Invalid operation: relation "context" does not exist;
This is my full query:
"Select order_num from order_table
where id >= " + context.a1 + " and id<= " + context.a2;

And two context variable has been defined as integer. Why does it give the error

Re: sql query on interger context variable

TRF — Fri, 19 Jan 2018 20:01:39 GMT

Very strange.
Can you share your tOracleInput settings?

Re: sql query on interger context variable

TRF — Sat, 20 Jan 2018 06:45:31 GMT

Based on your pm, what if you remove the semicolumn at the end of the query (or if you replace it by + ";")?