Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have created a job like
DBInput---> row1(main)--->tFlowIterate-->DBinput
I wanted to use the result of first query as input parameter to the second query.
I posted the schema of first schema column and the second schema query is like
SELECT * FROM myTable where COUNT(1) = " + ((Integer)globalMap.get("row1.count_group")) + ");
Getting error as: Error near row1
Can anyone help me out what am I missing?
Thanks in advance,
Meghana.
It's not working, still I am getting same error.
select * from "employee_detail" where age = '"+((String)globalMap.get("row1.system_user_id"))+"'
The above query I used for another job and it worked fine.
But, I am getting error for this job as I mentioned before.
Thanks,
Meghana.
I am still getting error
Configuration of which component first db or second db