I am able to capture two values in two separate contexts in the BPL. One through an API call and another by looking at the contents of PV1:7. These are context.Prov and context.ProvName. I am checking to see if the values contained in the contexts are the same and if yes process further and if not stop.

In the IF statement I tried the below but none worked. Can someone please tell me what I am doing wrong. The trace does show that they are the same value so that's not it.

1. context.Prov = context.ProvName

2. "context.Prov" = "context.ProvName" and

Hello,

I've the below datacombo definition and when selecting an item from it and make this call:

var component=zen("Component").getProperty("value");

I would get the ID (first column) which is what I'm looking for

Can someone help me on how the alter a table in Management table, I have tried the SQL and MYSQL way but it does not alter the table.

Thank you.

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan. My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect. If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for. To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be

Presenter: Paul Dayan
Task: Upgrade with minimal downtime
Approach: Provide examples of planning minimal-downtime upgrades from a variety of starting scenarios

When upgrading Caché, Ensemble or your application on your business-critical system, you want zero or minimum downtime. This session explores the problems and options when upgrading, and how mirroring can reduce or eliminate business disruption, with practical steps and a demonstration.

Content related to this session, including slides, video and additional learning content can be found here.

Where is InterSystems IRIS Download for Windows (better free)?

The question I have is if I run an External backup this library rotuine is called:
##Class(Backup.General).ExternalFreeze()

Is there a command I can run that shows me the Iris system is frozen due to the call to ##Class(Backup.General).ExternalFreeze()?

If the system is frozen I cannot sign into Iris terminal session.

I backup the IRIS server using Veeam. Veeam calls the "freeze" script, snapshots the server in VMWare, then calls the "thaw" script.
Veeam then backs up the VMWare snapshot.

Hi all,

I'm wondering if it is possible to call a Business Operation from other Business Operation.

I have a BO that writes logs into a database, using a personal message. I can create a set obj=##class(MyLogs).%New() but the BO has all parameters about connection.

Is it possible?

Best regards.

I'm trying to use the EnsLib.SQL.Operation.GenericOperation component in a production to read a column from a Redshift table that is set up as VARCHAR(65535) and am getting the following error.

An error was received : ERROR #5023: Remote Gateway Error: JDBC Gateway getClob(0,1) errorRemote JDBC error: Cannot convert the column of type VARCHAR to requested type long..

Has anyone had experience migrating source control projects from Subversion to Github, particularly when transitioning from InterSystems Studio to VSCode?

Hi Community,

Watch this video to see how HL7® FHIR® Implementation Guides allow you to restrict or extend APIs, resources, and terminologies:

⏯ What are HL7 FHIR Implementation Guides

https://www.youtube.com/embed/E9oRde9fHGE
[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]

At https://evaluation.intersystems.com/Eval/community-download/success/1391. I am not able to get the container version of the InterSystems kit.