how to use dual table in talend

[aambasht1626789554]

There are 2 date expressions passed as context variables.

ex:

EXTRACT_START_DATE= "TO_TIMESTAMP('2021-07-30_13:04:01.000000','YYYY-MM-DD_HH24:MI:SS.FF6')"

EXTRACT_END_DATE= "SYSDATE - INTERVAL '10' MINUTE"

I need to first evaluate the values and then use them in my talend job.

I tried using tDBInput with dual table but it doesnt work. It gives an error that the database schema is different from talend. How can i make it work.

Basically, i need output of :

"SELECT context.EXTRACT_START_DATE,context.EXTRACT_END_DATE from dual"

Are there other ways to do this?

[Anonymous]

Hi

If the query contains context variables, the syntax looks like:

"SELECT "+context.EXTRACT_START_DATE+", "+context.EXTRACT_END_DATE+" from dual"

If the query returns two values, you need to define two columns on the schema of tDBInput component to map the returned values.

Regards

Shong