Pass values from file to WHERE clause

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
pratyusha
Participant
Posts: 50
Joined: Wed Nov 22, 2006 4:58 am

Pass values from file to WHERE clause

Post by pratyusha »

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.

Thanks
Prathyusha
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If this is truly a Server job question as marked rather than a TX question per the forum of choice, then you've posted in the wrong forum and you need to repost it over in the actual Server forum.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply