Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi at all ,
I've necessary execute 2 query. The first query results is a parameter that I would use in second query.
For example:
1 Query: select max(date) from A
2 query: select count(*) from B where max(date.A) > max(date.B)
I would use max(date.A) like variable, so : Select count(*) from B where "variable" > max(date.B)
How I can do it?
Best regards
thnx at all
rhall_2.0 wrote:
It depends on how you want to use the value, timing, flow vs iterate connections, etc, etc. But as a start I would recommend returning your result from a db input component and then using a tJavaRow component to set the result to a context variable.
You might also want to look at the tContextLoad component as that might solve your problem in an easier way.