I have a need to lookup a ICD9 code based on a user account inside a ORU transaction and add it to the transaction for one route. There is a external server that does DB looksups to get me that data but I have to query this from the TPS inbound stream (or from route TPS). I learned that tcl sockets dont work inside TPS streams so I cannot open a socket connection from a proc. Any one has ideas on how to accomplish this