I want to pull data from a CSV file and put that all data in a SQL query.
SELECT emp_name FROM emp WHERE emp_name IN ('ABC','DEF','GHI','JKL','MNO')
I want these “emp_name” get into my SQL query form CSV automatically.
Forgot to mention -- this will be wicked slow and may make your DBA angry because it's calling that sql command over and over again. If you're going to do this in production, you should just index or lookup your database table and then do the whole job in SPL.