I have a flat file which has some 20 values in it. I have to run a query for these 20 values. So these values need to come into a WHERE clause. I have searched the forums to check for an answer but I am not able to find one. Is this approach possible? Can any one please suggest some ideas?
These values would be updated everyday. So I run a job to load the values into the flat file and then run another job with these new values.
your operating system is unix as you mentioned so it will be great that you create one more file which will have just one single record from your file which is having 20 values and use this file having single record for your lookup condition.
you can create a single record from file havig 20 records in your before job subroutine.
NO. That's too late as the job has already started. You need a Sequence job to gather the values and then pass them in to the Job Activity stage to run the job.
-craig
"You can never have too many knives" -- Logan Nine Fingers