How to set context variables with query result

[chichibio]

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

[Anonymous]

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.

[chichibio]

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.

It's a simple flow. Nothing else... 
Just read from table > put the result in variable and compare with another date from another db and table..finally count the difference of record.

[chichibio]

help me !!!  please

how I can do it!!thnx