possible to use tloop with dynamically changed variable for condition
Hi, I am doing a development, which requires to run mulitiple time of a job. I am thinking to use tloop with While clause. However, the requirement is the condition is coming from a variable, which may be changed. I am wondering how to use the condition in tloop while clause. Also I am wondering how to pass a variable to the sql in tPostgresInput.
Thanks,
Hello,
Does anyone knows how to read/parse a db table, for each record load fields in to the context variable, and execute subjob that uses these variables as parameters. Actually main problem is how to read fields from DBtable and store them in context variable. Also, how to save context variable in DBtable.
Thanks in advance
Zoran
Hello, Does anyone knows how to read/parse a db table, for each record load fields in to the context variable, and execute subjob that uses these variables as parameters. Actually main problem is how to read fields from DBtable and store them in context variable. Also, how to save context variable in DBtable. Thanks in advance Zoran
hi all, it could be solution to read each line and iterate the flow to "something" ? Seems like "for each line read data and do something with them".
TDB_output -> flow to iterate -> tRunJob
use the globalMap instead context var.(don't have to use javarow by that way) Even if i'm not a fan to pass flow's data with context variable to subJob . regards laurent
