Our ADT and Results interfaces each have an outbound thread that translates and then writes the messages to files on the local server. Once a day a Unix script runs that stops the threads and FTP’s the files over to the server where the database resides and those are then imported into the database by another script. Then there is an additional script that pulls out all the matching records from the database and writes them to a new file which is then placed on our Secure FTP server for pickup by our Business Partner.
George, thanks for replying.