All time

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 165
InterSystems Developer Community is a community of 25,100 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi Guys,

I've upgraded from Ensemble 2014 to 2018 and copied all classes across, ran Upgrade & CompileAll and looks fine, but when trying to search on dataCombo I get the below error

here is the definition of the Combo

0 3
0 166

Hey Community,

Watch this video to learn about the latest developments in client connectivity across Java, .NET, JavaScript, and Python:

⏯ Language Connectivity: New & Next @ Global Summit 2023

https://www.youtube.com/embed/v7TzuZ8AptA
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
1 169

Hey Community,

Join us to have a look back at recent developments in care planning and coordination and a look forward at what is on the horizon:

⏯ Unified Care Record: New & Next 2022 @ Global Summit 2022

https://www.youtube.com/embed/8HFIJ1D5h-A
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 169

Episode 16 of Data Points features a conversation with Jeff Fried — Director of Product Management for Data Platforms at InterSystems — about what it means for InterSystems to have been named a visionary in Gartner's first-ever magic quadrant for Cloud Database Management Systems.

https://5e18edf067eb59-03854285.castos.com/player/344317
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 0
0 169

Hey everyone.

It seems that my email address being updated with Intersystems has created a new account on here, and when I attempt to login with the old email address it logs into the new account meaning it looks like I have no post history.

Has anyone else faced this and have any advice on how to resolve it or any thoughts on if this is likely to affect other services like Learning and Global Masters?

0 3
0 166
Article
· Sep 28, 2015 1m read
Ensemble Virtual Documents TechFAQ

An introduction to virtual documents

Ensemble virtual documents enable your productions to work with large and complex documents with little overhead.

What is a virtual document?

A virtual document is a special kind of Ensemble message, for use with Electronic Data Interchange (EDI) messages and with XML documents.

How are virtual documents different from standard messages?

0 0
0 169

Over time, while I was working with Interoperability on the IRIS Data Platform, I developed rules for organizing a project code into packages and classes. That is what is called a Naming Convention, usually. In this topic, I want to organize and share these rules. I hope it can be helpful for somebody.

5 4
2 88
  1. I like the Application Error Log functionality a lot. However, it becomes time consuming to inspect it date by date and directory by directory on a multidirectory server. Ideally, I would use an existing error class to write a custom error report by date, selected namespaces, etc. Does such a system class actually exist? Not that I found. The detail level on the screenshot below is enough.
0 10
0 158
Question
· Jun 19
Namespace vs database

I'm confused about the differences between a namespace and a database.

I understand that a database is a single IRIS.DATA file in a directory in the os hosting IRIS.

What is the difference between a namespace and a database?

Can I write data into a database without specifying a namespace?
If so how do I write to a particlar DB in objectscript?

Does a database have to be in a namespace?
Can a database be in more than one namespace?

Can a namespace have only one 'routine' database and only one 'data' database?

0 8
0 160
Article
· May 29 8m read
Integrate with Google Forms

Google Forms is the most popular solution on the market for collecting data, answering questionnaires and quizzes. So, it is the ideal solution for collecting patient data and responses in a practical way, without the need to expand or develop systems. In this article, I will detail how to create an account on Google Cloud, register the application that will consume the Google Forms API, generate the service user necessary to consume the API and finally perform actions to create new forms and collect data filled in them in an automated way in embedded Python and IRIS.

Open Exchange app
2 2
2 128

I'm sure most of you are familiar with utility %SYS.MONLBL that is crucial when analysing code performance bottlenecks. It allows you to select a number of routines that you want to monitor at runtime and also specify what process(es) you want to watch. BUT, what if you do not know exactly, what process would execute your code? This is true with many web based (CSP/REST) applications today. You want to minimize the resource utilization on your production system that needs analysis. So, how about doing a small tweak?

1. Define an INC file with these macros:

7 2
2 128

We recently changed the 'UserID" property in a "User" class from type of %String to be %Library.Username. This is for better consistency across our codebase regarding MAXLEN limit.

%Library.Username is a system wrapper datatype which extends %String and has a MAXLEN of 160. This change should have minimal/no impact on code behavior. However, we found that some SQL query cannot return expected rows after the change. Query will return empty values even if the entry is in the table.

2 3
0 108

What settings do I need to just passthrough an X12 messages from a BS to BO and out the BO without modifying the message?

Currently, we are receiving the X12 messages but, it seems Iris is modifying it by "hiding" some segments like the ISA segment. The message goes out the BO modified and it doesn't reach its destination. Since I just want to pass it through, there is no BP, DTL, or Rule processing the message. Message is received by the BS and sent directly to the BO.

My current settings:

1 7
0 161

Anyone here know if the Implementation Partner program is still open, and if so, is there anyone we can contact to get more details? I've tried reaching out via the form on the website, I've called and left a message, and then I called and talked to someone a few weeks ago who said they would "forward my info over", but we still haven't heard back from anyone. We just want to get more info on what it entails, but can't seem to get in touch with anybody to talk about it.

1 1
0 167

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Transforming HL7 V2 Messages in Health Connect

https://www.youtube.com/embed/fA_0SXw4zgk
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 168

HealthShare Unified Care Record Fundamentals

October 31-November 4, 2022 9:00am-5:00 US-Eastern Time (EDT)

  • This 5-day course teaches HealthShare Unified Care Record users and integrators the HealthShare Unified Care Record architecture and administration tasks.
  • The course also includes how to install HealthShare Unified Care Record.
2 0
0 168

Hey Developers,

We love Global Masters program for dynamic, fun and networking. We love that we can get to know you better and provide you with some valuable things.

We are excited to have more members in Global Masters, and we'd like to ask your help on that:

❔ Do you know other developers who work with InterSystems technology and would love Global Masters?

▶ Here's the dedicated GM Referral page where you can leave your colleague or co-worker contact details, or get your unique referral link - to send it yourself 😊

0 0
0 168
Question
· Jun 30, 2021
OnMouseOver in a TablePane

Hi Guys,

is there a Onmouseover event in TablePane?

I'm looking to show an image when the user hover with the mouse on a specific Cell in a tablepane, any Ideas?

Thanks'

0 1
0 167