Generating the IN list for SQL query

[sonalkrishna]

Hi,

I am receiving an XML input file containing user ids. Now I have to look for those user ids in the table which are not mentioned in the input file and then send those retrieved user ids to output XML file....

Do I need to use a routine which removes tags from input user ids and collects them in a list or there is a simpler solution to do so?
Further,it is a RTI compliant job with RTI input and RTI output stages.
We are suppose to give the list of userids apart from those mentioned in the input to the front end.


Please advise.

Rgds
Sonal.