topic Re: Using context variable in postgresql statement in Talend Studio

Using context variable in postgresql statement

dwhdeveloper — Thu, 26 Jan 2017 12:36:55 GMT

I have created a context variable and i am trying to use it in postgresql input
In where clause I
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px '.SF NS Text'} span.s1 {color: #4237b0} span.s2 {color: #c13500}
where \"dwh01\".\"stg01\".\"table_name\".\"load_ts\"> '" + TalendDate.formatDate("yyyy-MM-dd HH:mm:ss", context.load_ts) + "'
It is not able to read my where statement.
Similar statement in mysql was working fine.
Is there a different way to use context variable in postresql ?

Re: Using context variable in postgresql statement

TRF — Thu, 26 Jan 2017 14:20:12 GMT

Hi,
Is it the complete where clause?
Do you have a compile error or a runtime error? Which one?

Re: Using context variable in postgresql statement

dwhdeveloper — Fri, 27 Jan 2017 16:59:40 GMT

I have updated the post with the real where clause.
There is no error.
It seems that it does not filter by the context variable.
I tested the context variable with tjava output and context variable is working fine.