All time

Example:

Method Execute (args...) As %Status {
...
 #dim statement as %SQL.Statement
 set statement = ##class(%SQL.Statement).%New(2)
 set statement.%Dialect = "CACHE"
 do statement.prepare(query)

 #dim rs as %SQL.StatementResult
 set rs = statement.execute(args...)

My questions are: 1) how do I get the size of args **2) how to get all values of **args **3) is it possible to modify the **args?

0 6
0 454
InterSystems Developer Community is a community of 25,935 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

This week I was able to demo a proof of concept for our FMS interface on traffic cop architecture to my team. We are working on modernizing an Interoperability production running on mirrored Health Connect instances. We deploy IRIS workloads on Red Hat OpenShift Container Platform using InterSystems Kubernetes Operator (IKO). We can define any number of replicas for the compute stateful set where each compute pod runs our Interoperability production. We introduced Horizontal Pod Autoscaler (HPA) to scale up the number of compute pods based on memory or CPU utilization.

5 0
0 460

Hi Developers!

We had a set of technology bonuses for the InterSystems IRIS Developer Tools contest.

And here is how projects collected it:

Project docker zpm Unit Testing Online Demo Code Quality Article on DC Video on YouTube Total Bonus
Nominal 2 2 2 3 2 2 3 16
Config-API 2 2 2 2 2 10
Server Manager for VSCode 2 2 4
Grafana Plugin for InterSystems 2 2 2 6
SSH for IRIS container 2 2 3 7
IntelliJ InterSystems 2 2
gj :: locate 2 2 3 7
helper-for-objectscript language extensions 2 2 2 2 3 11
IRIS REST Documentation 2 2 4
IRIS-easy ECP workbench 2 2 2 2 3 11
zpm-explorer 2 2 2 3 2 2 3 16
Git for IRIS 2 2 2 6
zapm-editor 2 2 2 6

0 9
0 280

Hello,

I have established an ODBC connection with our client based on credentials they provided. The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties. However when we try to execute a query in IRIS we are getting error code -226. I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client.

We have tried with PostgreSQL as well as with TSQL. Same result for each.

0 3
0 457
Job
· Jan 5, 2021
#Job Opportunity

We are looking to hire a DevOps engineer with expertise in Intersystems Technologies like Ensemble and/or IRIS as essential.


Main responsibility of the Role will be to implement Version Control and automated CI/CD pipeline for code build and deployment via tools and automation scripts for the current Intersystems platforms within the organisation.

If interested please email your resume to utsavi.gajjar@mater.org.au

0 0
0 460

Hi all, I am having problems trying to get Docker to run correctly on my Linux Mint machine.

I did the following:

1. Installed Docker.

docker --version

Docker version 19.03.6, build 369ce74a3c


docker-compose -v

docker-compose version 1.17.1, build unknown

2. Downloaded zip from https://github.com/intersystems-community/iris-fullstack-template/tree/42f9c174a9a4e63cb5eb3eb646abf3930a6e4d31

0 1
0 459

I've recently encountered a HS Caché that won't start informing that Collation 30 is not available, but I have not found an easy way of knowing what collation is 30.

I've found that the following command returns the ones from the current locale, but not from all locales:

Set Rset = ##class(%ResultSet).%New("%Library.Collate:CollationList")

d Rset.Execute()

While (Rset.Next()) {zw Rset.Number_": "_Rset.Name}

Thank you

0 2
1 458

Hi Developers,

2019 was a really great year with almost 100 applications uploaded to the InterSystems Open Exchange!

To thank our Best Contributors we have special annual achievement badges in Global Masters Advocacy Hub. This year we introduced 2 new badges for contribution to the InterSystems Open Exchange:

✅ InterSystems Application of the Year 2019

✅ InterSystems Developer of the Year 2019

We're glad to present the most downloaded applications on InterSystems Data Platforms!

2 0
0 460

Hi hi,
Is there any way to do an automated daily print-to-PDF of a dashboard (its' widgets / pivots etc)?
I am able to add a "Print" Control to a Widget on a dashboard to do the default DeepSee Print functionality of a Control, but this is manual and browser dependent.
Is there a way I can either:
1) have say a scheduled task to automatically print the dashboard (as and instead of the manual Control click) including specifying filename?

0 4
0 456
Question
· May 4, 2016
Atelier and overriding

I'm used to using Class/Refactor/Override in Studio to override methods, properties, xData blocks, etc regularly.

I can't see how to replicate that in Atelier at the m moment. Is this possible ?

3 2
0 458

Hello!!!

Data migration often sounds like a simple "move data from A to B task" until you actually do it. In reality, it is a complex process that blends planning, validation, testing, and technical precision.

Over several projects where I handled data migration into a HIS which runs on IRIS (TrakCare), I realized that success comes from a mix of discipline and automation.

Here are a few points which I want to highlight.

1. Start with a Defined Data Format.

Before you even open your first file, make sure everyone, especially data providers, clearly understands the exact data format you expect. Defining templates early avoids unnecessary bank-and-forth and rework later.

While Excel or CSV formats are common, I personally feel using a tab-delimited text file (.txt) for data upload is best. It's lightweight, consistent, and avoids issues with commas inside text fields. 

PatID   DOB Gender  AdmDate
10001   2000-01-02  M   2025-10-01
10002   1998-01-05  F   2025-10-05
10005   1980-08-23  M   2025-10-15

Make sure that the date formats given in the file is correct and constant throughout the file because all these files are usually converted from an Excel file and an Basic excel user might make mistakes while giving you the date formats wrong. Wrong date formats can irritate you while converting into horolog.

4 12
2 219

How do I write DDL script for collection properties?

For example I want to create the following class:

Class SQLUser.Person {

Property Name As %String;

Property FavoriteColors As list Of %String;

}

My DDL script looks like this:

CREATE TABLE Person (Name varchar(50), FavoriteColors ???)
0 5
0 454

DNA Similarity and Classification was developed as a REST API utilizing InterSystems Vector Search technology to investigate genetic similarities and efficiently classify DNA sequences. This is an application that utilizes artificial intelligence techniques, such as machine learning, enhanced by vector search capabilities, to classify genetic families and identify known similar DNAs from an unknown input DNA.

Open Exchange app
2 2
1 419

Reviewing a client console log, I am finding the message:

Terminal disconnect: The specified network name is no longer available.

This message is repeated in the log dozens of times per day over the last month. The client has not raised a concern and our monitoring has not detected any issues with client ops. The client is not aware of any recent changes with their apps. I am not familiar with this message and whether this message is benign or whether there is any action required,

0 1
0 458

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Real-World CI/CD: Keep Calm & Build On @ Global Summit 2022

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

Hey Developers,

Good news! One more upcoming in-person event is nearby.

We're pleased to invite you to join "J On The Beach", an international rendezvous for developers and DevOps around Big Data technologies. A fun conference to learn and share the latest experiences, tips & tricks related to Big Data technologies, and, the most important part, it’s On The Beach!

🗓 April 27-29, 2022

📍Málaga, Spain

This year, InterSystems is a Gold Sponsor of the JOTB.

We're more than happy to invite you and your colleagues to our InterSystems booth for a personal conversation. As always, there will be some surprises on it... 😁

2 0
0 459

Hi Team,
I have a requirement to disable the Production Start/Stop buttons for specific support users. But they should be able to stat/stop Ensemble Hosts.
For that new Role, As per documentation along with other Ens resources, I have added %Ens_ConfigItemRun with RWU access and didnt add %Ens_ProductionRun resource.

This makes the Start/Stop buttons disappear from Production Configuration page ( meeting my requirement). But those users are Unable Start/Stop/Restart Ensemble Business Hosts.

0 3
0 456
Question
· Mar 5, 2021
Exam-taking

What are the differences among HealthShare Health Connect HL7 Interface Specialist, InterSystems IRIS Core Solutions Developer Specialist and HealthShare Unified Care Record Technical Specialist these 3 certifications? And what are the prerequizites for these 3 exams?

1 3
0 456

Hey Developers,

The recording of the Kick-Off Webinar for InterSystems IRIS Native API Online Programming Contest is now available on InterSystems Developers YouTube:

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

Speakers:
@Bob Kuszewski, InterSystems Product Manager
@Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Open Exchange app
2 5
0 359

Hi Developers!

This post describes how you could publish your InterSystems application on Open Exchange.

What is the InterSystems application?

It could be anything, which is built with InterSystems data platforms or to help work with InterSystems data platforms: InterSystems IRIS, InterSystems IRIS for Health, InterSystems HealthShare, InterSystems Ensemble and InterSystems Caché. This could be tools, frameworks, adapters, examples and business solutions.

Why publish on Open Exchange?

InterSystems Open Exchange is an "App Central" for the solutions in InterSystems. It's the first place where the developer goes to look for tools, frameworks, and examples on InterSystems IRIS. And Open Exchange brings the added traffic to your solution which could be converted into leads.

We are having a set of business development tools for published Open Exchange applications. This definitely makes your InterSystems application more noticed.

Submitting an application

Suppose you have a library with open source published on Github which you want to publish on Open Exchange. For the purpose of a demo, I'll fork this remarkable project of @Peter Steiwer ObjectScript-Math which I forked and renamed to object script-super-math.

1 2
0 419