Is there some generic way to output a %SQL.StatementResult to CSV?
Hi
How to get shadow status with command line, to monitoring ?
Preview releases are now available for the 2021.2 version of InterSystems IRIS, IRIS for Health, and HealthShare Health Connect.
As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability release next month. Please share your feedback through the Developer Community so we can build a better product together.
InterSystems IRIS Data Platform 2021.2 makes it even easier to develop, deploy and manage augmented applications and business processes that bridge data and application silos.
I am trying to connect to an external SFTP. They have our public key and I have the private key which is password protected. I have the credentials set to the sftp username and the password to the private key.
If I set the private key only, I get a username/password error connecting. If I set both the public and private key files, I get the error below:
ERROR #7510: SSH Error '-19': SSH Error [80101013]: Callback returned error [80101013] at Session.cpp:418,0
I have this working perfectly using filezilla, however I can't get it to work with EnsLib.FTP.PassthroughService.
Hello Everyone,
In October 2021 we asked for input from the IRIS community regarding exam topics for our InterSystems IRIS System Administration exam. We will close the window for providing feedback on the exam topics on Wednesday, January 12, 2022. Thus, if you would like to have your say in what topics are covered on the exam, this is your last chance!
Extra perk for US-based, non-InterSystems employees: To show our appreciation for helping us validate our exam design, we will offer the first 20 volunteers that complete the survey a $50 gift card.
Hi Developers
As you know it's very easy to publish a package to the Developers Community registry.
But how to test it before publishing? How to be sure that everything you introduced into module.xml is installed properly?
See the step-by-step instruction below!
For those of you who might be new to IRIS, and even those who have used Cache or IRIS for some time but want to explore beyond its usually-assumed boundaries and practices, you might want to dive into this detailed exploration of the database engine that is at its heart, and discover just what you can really do with it, going way beyond what InterSystems have done with it for you.
You'll discover that it's actually a hugely powerful yet incredibly simple storage engine that allows you to model any kind of database you wish, once you understand and master its simple, basic principles.
Hey Community,
Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in December 2021:
We’ve already considered how to run an IRIS-based application in GCP Kubernetes in Deploying InterSystems IRIS Solution into GCP Kubernetes Cluster GKE Using CircleCI. Additionally, we’ve seen how to run an IRIS-based application in AWS Kubernetes in Deploying a Simple IRIS-Based Web Application Using Amazon EKS. Now, let’s look at how to deploy an application to the Azure Kubernetes Service (AKS).
What is the correct data type for decimal numbers precision 5?
I tried %Numeric with Scale 5, but not worked, see:
Classdc.data.health.BreastCancerExtends%Persistent[SqlRowIdPrivate]
{
ParameterScale=5;
///Mean of distances from center to points on the perimeter
PropertyradiusmeanAs%Numeric;
The "Download Caché Evaluation" at the top of this forum takes the user to a page that only allows her to download versions of IRIS. What am I missing here? Does IRIS encompass Caché? I've wandered around both on the main website and in the Developer Community site looking for a way to only get Caché... Very frustrating.
I appreciate any help you all can provide. Thanks!
Hey Developers,
Ready to participate in our annual December competition?
Join the Advent of Code 2021 with InterSystems and participate in our ObjectScript contest to win some $$$ prizes!
So I've been reviewing a lot of questions posted in the InterSystems community regarding NULL properties in JSON. I've also been reviewing the JSON documentation. None of these things have been able to help me so far.
1. We don't seem to have the %JSON.Adaptor class available for us to use in our system.
2. I'm not really confident enough to create JSON Type classes or backporting code, etc.
I created a dummy class and I need my JSON to look like this:
{
"notanumber":"28001",
"aboolean":true,
"anumber":12345,
"adecimal":1.
Is it possible to call java programs inside SQL statements, like the new LOAD Data, or is this just internal?
I Have a problem with a Signature validator to XML file, when this file have more than one Signature tag.
Like This
<nfeProc xmlns="http://www.portalfiscal.inf.br/nfe" versao="4.00">
<NFe>
<infNFe Id="NFexxx" versao="4.00">
...
</infNFe>
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#">
<SignedInfo>
<CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315" />
<SignatureMethod Algorithm="http://www.
<NFe>
<infNFe Id="NFexxx" versao="4.00">
...
</infNFe>
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#">
<SignedInfo>
<CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315" />
<SignatureMethod Algorithm="http://www.
Hi Team,
I want to generate HL7 based on passing the HL7 version in InterSystems IRIS.
If there is any possibility to implement in InterSystems IRIS or not?
If yes, then give a solution regarding for same.
Thanks,
Harshdeep Acharya
Hello everyone! Don't miss the Developer Community Post Digest for December 2021.
General Stats
✓124 new posts published in in December:
– 25 new articles
– 38 new announcements
– 58 new questions
– 3 new discussions
✓199 new members joined in December
✓8,911 posts published all time
✓10,288 members joined all time
– 25 new articles
– 38 new announcements
– 58 new questions
– 3 new discussions
✓199 new members joined in December
✓8,911 posts published all time
✓10,288 members joined all time
Hey Developers! Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in December 2021.
General Stats:
✓ 15 new apps in December
✓ 703 downloads in December
✓ 562 applications all time
✓ 15,816 downloads all time
✓ 1,457 developers joined
✓ 703 downloads in December
✓ 562 applications all time
✓ 15,816 downloads all time
✓ 1,457 developers joined
Hello,
I have a question about defining properties for various of services, operations and processes in Productions. Let’s say I have developed a container running an IRIS instance with a single namespace and a production with pre-defined set of components. I’m planning to deploy this container to dev, staging and production environments. These different environments use different settings for the operations, etc. For example, dev-environment could use some test endpoint for an HTTP component, e.g. https://testdomain.com/test and production environment https://proddomain.com/prod.
Hi Devs!
Recently, I needed to create templates for newsletters.
I couldn't find any tools, so I decided to use the CSP (Caché Server Pages) to build the templates.
Let's figure out how to make a newsletter similar to Weekly OEX Digest.
.png)
Weekly OEX Digest
There are strict requirements for HTML email messages.
Basic requirements:
- The page should be static;
- You have to use inline styles for mailer compatibility (so much code);
- Use custom fonts, some images, etc.
I am a newbie who is trying to learn how to set up a basic connection to Iris using a node js application. I am astounded at the lack of documentation there is on how to do this and even more concerning there are a few errors within the documentation. For example I am on the Native API application within the below link.
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…
And it says that you need to create a directory the thing is that it doesn't state which directory this needs to be or any other history.
trying to lock a table via .Net Command results in IrisExcpetions no mater what i try;
Documentation says the Command is supported by TSQL Implementation - any known tricks how to implement this comand?
Hi all,
I try to build a little project for the dataset contest, you can find it here on github: Openflights dataset
My plan is to use just plain SQL. So I've made a few experiments with the new feature LOAD DATA.
Unfortunately all loads produce errors like:
Error: [SQLCODE: <-400>:<Fatal error occurred>]
[Error: <<UNDEFINED>zExecute+83^%sqlcq.OPENFLIGHTS.cls4.1 *%qparsets>]
[Location: <ServerLoop>]
The statements I use looks like this:
This happend with the preview release "IRIS Version 2021.2.0.617". While this error occurs, most rows are written to the database, but some rows are missing.
For me the best moments were:
1 - Global Masters WON the 2021 Influitive BAMMIE Award for Most Passionate Community
2 - Tech Article contests
3 - InterSystems Programming Contests
4 - 10,000+ DC members
5 - Partner directory and business services
6 - 500+ applications on OEX
7 - Open Virtual Summits
8 - Prizes from GM points
9 - Free online learning courses
10 - Discord channels
11 - Innovations from IRIS Data Platform
12 - Multilanguage communities, including portuguese, spanish and chinese community
13 - Advent of Code
The XData (https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GOBJ_XDATA) is a powerful feature to set documentation and metadata information for classes and methods. The %CSP.REST class uses XDATA to mapping REST calls (https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GREST_csprest), so in this article you will see how to use XData into your apps as code, not only as documentation.
When you write XData comments/definitions, the IRIS store it into %Dictionary.ClassDefinition (for classes) %Dictionary.MethodDefinition (for methods).
Hi
I am a very experienced Ensemble and IRIS developer who has spent his entire career either working for InterSystems or with their products. I was a Senior Sales Engineer with InterSystems for 14 years with a further four years working for InterSystems TrakHealth. I started working for the InterSystems UK office and from there I spent several years travelling to InterSystems offices in Europe, Scandinavia, the Middle East, Israel and eventually ending up in the South African office. I moved back to South Africa in 2001.
Hi Community,
We are pleased to invite all the developers to the upcoming InterSystems Datasets Contest Kick-off Webinar! The topic of this webinar is dedicated to the Datasets contest.
In this webinar, we’ll do a quick tour of the new LOAD DATA feature, also chime in on packaging global data or file data with ZPM, and run a data-generation script as part of a method in the zpm install.
As always, our experts will answer the questions on how to develop, build, and deploy datasets using InterSystems IRIS.
Date & Time: Tuesday, December 28 – 10:00 AM EDT
Speakers:
🗣 @Benjamin De Boe, Product Manager, InterSystems
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager
Where can I download the ODBC35 driver version 2018.1.4 64 bit?
Is there a way to make listbuild from java?
Something like:
IRIS iris = IRIS.createIRIS(conn);
byte[] value={1,2,3,4}
iris.set(value,"^testglobal");
but this creates set ^testglobal = $c(1,2,3,4).
Hi,
In a Business Operation i have the following code.
I need the identity of the latest row inserted in a table in MSSQL.
i Have the following code:
---------------------------------------------------------
set insertmaster= "INSERT INTO dbo.dataMasterArchive(deviceToPatientLogID) values (?)"
set tSC = ..Adapter.ExecuteUpdate(.nrows1,insertmaster,pRequest.deviceToPatientLogID)
$$$ThrowOnError(tSC)
set sql ="SELECT SCOPE_IDENTITY()"
set tSC = ..Adapter.ExecuteQuery(.tResult,sql)
$$$ThrowOnError(tSC)
set maxID =
