Any ideas on how I can easily de identify production messages so that I can use them in TEST?

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?

Hi,

I'm trying to access to my datas stored in a RecordMap from SQLAlchemy, and I need to access to any tables already created before using SQLAlchemy.

Here is some part of my code :

TestBase:

I have a fixed width complex recordmap that is an older version of a file format. I am trying to retool it to fit the latest version. The old recordmap has almost 500 entries on it and the new version has a few more fields added along with changes to some field lengths. Adding a new field adds it at the end of the recordmap and moving it from field 490 to field 139 is a painful process. Is there an easier way of doing this?

#Mapping
@Jenna Poindexter
@Ashok Kumar
@AndreClaude Gendron
@Saul Bloom

InterSystems FAQ rubric

The TIMESTAMP type corresponds to the %Library.TimeStamp data type (=%TimeStamp) in InterSystems products, and the format is YYYY-MM-DD HH:MM:SS.nnnnnnnnn.

If you want to change the precision after the decimal point, set it using the following method.

1) Set system-wide

Hello, I created HL7 router Extends Ens.Rule.Definition. When I click the dot to the left, it does not draw lines to targets. I tried to add ClassMethod OnGetConnections(), but it does not get executed.

I have a production that writes x12 file with a EnsLib.EDI.X12.Operation.FileOperation. I am trying to get file name that was used back to the business process. What is the best way to do this?

Hi,

On referring this link : https://community.intersystems.com/post/my-first-experience-using-iam

What should be the host and port while creating a service when the communication is been setup in local? Also, please provide the URL to be called using Postman to send a request to IAM.

Hi,

I use the data functions but don't know what they all do. Is there a dictionary that explains what each function does?

Thanks,

Lai Pham

In our previous article we presented the general concepts as well as the problem that we wanted to solve by using the task engine integrated in InterSystems IRIS, in today's article we will see how we configure an interoperability production to provide a solution.

Workflow Engine Configuration

First we are going to define the roles of the tasks that we are going to manage, in our example we are going to define two types:

Principle: After dividing the article uploaded by the user into sentences using Python, the embedded value is obtained and stored in the Iris database. Then, the similarity between sentences is compared through Iris vector search, and finally displayed on the front-end page.

Have successfully installed the Intersystems ObjectScript Extension Pack (version last updated 2024-03-26) in VS Code version 1.88 and when creating a new Class (in a New File of type ObjectScript-class) I am presented only with the following snippets:

Hi,

I have succesfully installed IRIS client on MacOS (see bottom half of this post). What's next? How do I access the menu to launch IRIS Client, access Studio, and connect to remote server etc??

Thanks,

W

----------------------------------------------------------------------------------------------------------

$$> sudo sh /Users/xxx/Downloads/HealthConnect-2023.1.3.517.0-macx64/irisinstall_client

Password:

Your system type is 'Mac OS X/x86/64-bit'.

Enter a destination directory for client components.