Possible to pass a set of keys (Hashin) to a database read component like tDBInput (JDBC) to filter records read?

[slupdike]

Hello all, I have isolated a group of keys (GUIDs) in a hash file that i want to pass into a database read component (tDBInput JDBC). I am trying to avoid reading the entire database table just to use a tMap to match on and isolate a handful of records. Almost like i need to use a hashinput as the JOIN in a SQL SELECT statement. Is this possible? I apologize if this is already answered, but it is extremely hard to find the proper words to form query - I tried everything i could think of, but was unsuccessful. Thank you.

[Anonymous]

Hello,

If we understand your requirement very well, are you trying to using context variables in where clause of select statement?

Could you please elaborate your case with an example with input and expected output values?

Best regard

Sabrina