Hi everyone.

I have a function that may end up being called from a number of transformations at the same time, and within the function there's some Embedded SQL to first check if a local table has an entry, and then adds the entry if it doesn't exist.

To prevent a race condition where the function is called by two transformations and they both end up attempting to insert the same value, I'm looking to use the table hint "WITH TABLOCK" on the insert, but this seems to be failing the syntax checks within vscode.

Are table hints supported with embedded sql?

0 4
0 63

I recently set up InterSystems in the Azure cloud environment. So far, no issues. Recently, I was tasked with uploading the IRIS.dat file (FoIA VISTA) into the instance. I was guided by my teammates to do the following: System Administration > Configuration > Local Databases. The problem is that I need to transfer the .dat file to the instance, because, as it is running on a local machine, it cannot retrieve files from my local drive. Is there a reliable solution, such as a transfer method or way of using the Web Gateway endpoint, one can provide to assist?

0 2
0 39

The users wants the ability to modify the logic used to populate PID:22 depending on the value of PID: 39. The logic is as follows

If both PID:22 and PID:39.2 are null then set PID:28 to "Unknown"

If PID:22 and PID:39.2 are not null and are the same value, then populate PID:28 with PID:39.2

If PID:22 and PID:39.2 are not null and are different, then set PID:28 = "Undetermined"

Setting this condition in a transform is straight-forward,.

0 1
0 12

I am attempting to configure an inbound service that utilizes the EnsLib.SOAP.GenericService class. This service receives HL7-v3 content wrapped in SOAP requests. Despite reading the documentation on configuring SOAP services, I am still confused.

In my current configuration item "Fr_Centrak_RTLS", I have ‘Enable Standard Requests’ checked, ‘Pool Size’ set to 0, and the port is unspecified.

0 1
0 20