Using IN clause

[DSTXEAI]

Hi,

How to pass multiple parameters dynamically to an IN clause in the map rule.

We have vendorIDs in the input file and I want to retrieve vendor information of all the vendorIDs that are exist in the input file from DB.

I tried the below way and not able to succeed.
1.Fisrt I have retrieved all the vendorIDs from the input file to card 1.
2.Passed the output of the card 1 to the IN clause of the card 2 and I am able to get only the first value from card 1 even though I have used the EXTRACT function.

Please advise.

Thanks,
Suresh

 

[janhes]

The best way is to run a second map that does a query to the databawse with a variable for the Vendor ID and pass the vendor ID from the calling map. That gives you a structured layout of your database query. You can then use this map to process the data.