It's possible to enable Ctrl+C / Ctrl+V in IRIS Terminal for Windows.

To do that, open Terminal and select Edit > User Settings and enable Windows edit accelerators. This setting specifies whether the Terminal enables the common Windows edit shortcuts (Ctrl+C, Ctrl+V, Ctrl+Shift+V), in addition to the basic Terminal edit shortcuts (Ctrl+Insert and Shift+Insert).

After that Ctrl+C / Ctrl+V would work.

Also <SYNTAX> errors after incorrect copy/paste go away.

Docs.

Hi everybody,

I love the integration of HL7 v2.x in Ensemble, it's really easy to use.

I would love to see the same about using CDA on Ensemble. I know it's a complicated standard, but it would be more easy for developers in Europe if we could use it like any other type of message instead of using at XML level and xsl transformations.

Any experiences dealing with CDA on Ensemble?

Is there any issue with using a pool size setting greater than 1 for an inbound file service? The reason I ask is we can easily dump 100k+ files to a folder in minutes, but using a pool size of 1 can take hours for that backlog to clear.

Hi,

I know json does not impose any order, but for readability I would like to insert a json property at a specific location at the start of a %DynamicObject, not at the end.
Is there a known way to do that (other than string manipulation)?

Hello Everyone,

I was wondering about the best way to initialize several variables, or several lists of variables.

Would it be better to write it like:

set (var1, var2, var3) = "value1"
set (var4, var5) = "value2"
set (var6,var7,var8) = "value3"

or

set var1="value1", var2="value1", var3="value1", var4="value2", var5="value2", var6="value3", var7="value3", var8="value3"

or

Without installing Kerberos has anyone Authenticated a SQL JDBC connection? Currently we are using local SQL Accounts to sign onto External SQL Databases, but we are being told that we need to switch to Service accounts that live on a Active Directory Domain.

I wrote with a little help a ZAUTHENICATE to do the Authentication for Ensemble, can I use something like that to connect to an External SQL Database using a Service Account on a Active Directory Domain?

Thanks

Scott

Hi, is possible rewind results of %SQL.StatementResult?

I not find a solution.

Hello experts,

Good afternoon. I am a new member here and was wondering if any of you can help me with creating my own instance of Healthshare with MPI. This will serve as a sandbox and a learning environment for me. What is the minimum requirement to have such an environment setup, meaning will I only need to setup HSBUS, HSREGISTRY(HUB), MPI, HSACCESS, and EDGE Gateway(s)? If so, how do I properly set them up without just installing an environment with ENSDEMO?

There is an interesting new feature in the recently announced 2024.1 preview, JSON_TABLE. JSON_TABLE is one of a family of functions introduced by the 2016 version of the SQL Standard (ISO Standard, published in early 2017). It allows for JSON values to be mapped to columns and queried using SQL. JSON_TABLE is valid in the FROM clause of some SQL statements.

The syntax of JSON_TABLE is quite large, allowing for exceptional conditions where the provided JSON values don't match expectations, nested structures and so on.

InterSystems FAQ rubric

It can be obtained by using the Size query of the system-provided %SYS.GlobalQuery class.

Hi,

I have tried to install the module git-source-control into my USER namespace, but get the following error.

ERROR! ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={2763|2764}>
> ERROR #6084: Unknown errors detected, but no error code reported

Hi,

We have a system that gives an AE 'Error' response for warnings, that we want to transform to AA codes when returning the Application ACK.

MSH|^~\&|iCS|EHT|EPRO|R1K|20180511113136||ACK^A02|fbwZaoKW/USAdFI3IGLU|P|2.3|||AL|NE|
MSA|AE|fbwZaoKW/USAdFI3IGLU||||0^Nothing To Update^^W
ERR|||0^Nothing To Update|W|

Fortunately they include a warning code in MSA:6.4 and ERR:4

How do you cancel a query that is executing in the Management Portal > System > SQL?

Does closing the browser cancel the query or does it continue to run in the background?

Is there any added benefit to using the Shell over the Portal? Perhaps there is a way to cancel/stop a query here?

$SYSTEM.SQL.Shell()

Thanks