I am facing a problem while doing lookup on ODBC stage. As it is is multi-row lookup, I am using ODBC stage.
My seq file contains, various empnames is single row in following format:
Kirti,Kumar,Amol
Sachin,Mark,John,Chris,
I want fetch all rows from Emp table where empname is from the list of each row i.e. wanted to put SQL like
Code: Select all
select * from emp where empname in (?)
any inputs will be appreciated.