Hi,
in tMap it is not possible to lookup additional information with a dynamic sql query.
My tSybaseInput_1 is only fired at startup of my job, but i want to query the database for each row.
In tJavaRow_1 i also set the contextvar "currentAZ", which is used by tSybaseInput_1
Do you have a suitable solution, i don't want to fetch the whole table in tSybaseInput_1.
Query in t_SybaseInput_1:
"SELECT
AZ
FROM FCAdmin.Akte
WHERE AZ = '"+context.currentAZ+"'"
Thanks and Regards
Sebastian