User bio
404 bio not found
Member since Nov 11, 2020
Posts:
Replies:
Hi Alexander.
Sorry for being pedantic, but you're missing the ending quotation mark when setting the value of 'sql'
SET variable = 2000
SET sql = "SELECT Column FROM Table WHERE ID = ?"
DO ##class(%SQL.Statement).%ExecDirect(, sql, variable)I have faced similar in the past, and I found the easiest way to manage this was to add a router at an early stage of the process to act as a pre-processor which makes the initial change once. Something like:
.png)
Certifications & Credly badges:
Julian has no Certifications & Credly badges yet.
Global Masters badges:
Followers:
Following:
There are a few options you could go for here. One would be to have your DTL go from your HL7 Message to Ens.StreamContainer, and then use a code block in your DTL to create and write the stream to store in the stream container.
Something like:
Set stream = ##class(%Stream.GlobalBinary).%New() Do stream.Write(yourTextString) set streamContainer=##class(Ens.StreamContainer).%New(stream)(Above is untested, and you may need to set other values within the container.)
You can then use the operation class EnsLib.File.PassthroughOperation to then write the file out to your desired location.