Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Timing of Database look up

Question
Scott Roth · Apr 12, 2019

Timing of Database look up

We use a lot of external MS SQL calls to look up numerous things when it comes to HL7. I am running into an issue where the outbound calls are queued but the message is sent onto the next process before it gets a response. How do I get it to wait till the response gets back from the MS SQL call before sending it onto the next process?

 

Below is a screen shot of what I am trying to explain...Select Research Study executes at 8:33 the message is sent to the next process at 8:34, but the response of the MSSQL call doesn't come till 9:31.

#ObjectScript #SQL #Ensemble

Source URL:https://community.intersystems.com/post/timing-database-look