Check hl7 and db before to send the hl7 message

Hi all,



I try to explain my problem.

I would like to check all the hl7 messages in a folder A, for each message:

I have to check the value of a field and decide what to do

-> if the value is already present in an external database I have to send the message in a different folder B, if not I have to insert the value in the database and THEN send the message in a different folder C.



I´m not sure how to do the first part (checking and possibly write in an external database with a file reader? change the destination according on a field of the incoming message? how?), any suggestion?



I hope the question isn´t already made, and if it´s a very simple problem I´m sorry again but I´m a very newbie.



Thanks to anyone who can help.

Check hl7 and db before to send the hl7 message