I was never able to get this to work, and now I have another case where I need to do something similar as I have a linked table that is dynamic and need to use as a filter in a router. Can someone see what I might be doing wrong?

Thanks

Scott

I keep getting the following...

ERROR <Ens>ErrException: <UNDEFINED>zTransform+134 ^osuwmc.EpicOMStoMatSysTecsysBkLoad.1 *%Ensemble("FeederScottRouting") -- logged as '-'
number - @'
set bp = %Ensemble("FeederScottRouting")'

So...

%Ensemble("%Process") should be the Business Process (aka Router) that is calling the original DTL?

I think I found a way to handle it but I am struggling on how to send an Ens.Request message to another Operation in the middle of a DTL. I tried this through a function, but Ensemble does not recognize the SendRequestSync that I am trying to send.

Is it possible to send another message to another Business Operation using Code/Function in the middle of a DTL?

You could use Piece to separate the values in Par_Locations.

For those that do not know what those tools are and are just getting into SQL, navigating around the tool within IRIS/HealthShare can be difficult at times. Even trying to use those tools can be complicated in setting up the necessary connections and settings.

I would like to see a more modern SQL management/editor within IRIS.