Temporary tables are tables available for a current process only (and destroyed when process ends).

What are you approaches to creating temporary tables?

just wondering - is there any reason why IRISList doesn't accept decimal values?

.. IRISList would be very handy und useful - but if i have to build a wrapper to serilize/ deserilize decimals ...

Ready to build an HL7 production all by yourself?

Try the new Building Your First HL7 Production with InterSystems IRIS for Health learning path from InterSystems Online Learning.

These videos, online courses, and hands-on exercises get you building, optimizing, and troubleshooting productions with InterSystems IRIS for Health. See for yourself!

We need to get service's both source and target names. We have checked that we could obtain them in the service:

set ^sourceName = ..#SERVICENAME

However we would like to get it directly from the BPL. We have tried:

Hi Developers!

It's just a statement to let you know who is working for you this year as Developer Community Moderators. Here is our noble team!

English Community:

@Eduard Lebedyuk

@John Murray

@Dmitry Maslennikov

@Robert Cemper

@Jeffrey Drumm

@Scott Roth

Spanish Community:

@Kurro Lopez

@Nancy Martínez

Moderators! thanks for your hard work to make this place busy and helpful!

Developers! You can meet in person all the moderators on InterSystems Global Summit 2020 in Seattle this year and on regional events.

Stay tuned!

Hi Developers!

Here are the release notes of changes we made to InterSystems Open Exchange since the previous release in December 2019. What's new?

• Email notifications and subscriptions;
• Better UI/UX for application publishing process;
• Mobile UI for tablets and phones.

See the details below.

InterSystems and Intel recently conducted a series of benchmarks combining InterSystems IRIS with 2nd Generation Intel® Xeon® Scalable Processors, also known as “Cascade Lake”, and Intel® Optane™ DC Persistent Memory (DCPMM). The goals of these benchmarks are to demonstrate the performance and scalability capabilities of InterSystems IRIS with Intel’s latest server technologies in various workload settings and server configurations. Along with various benchmark results, three different use-cases of Intel DCPMM with InterSystems IRIS are provided in this report.

I'm working on developing Productions with java. The sample project has several intersystems jar files:
-- intersystems-enslib-jms-3.1.0.jar
-- intersystems-gateway-3.1.0.jar
-- intersystems-jdbc-3.1.0.jar
-- intersystems-spark-1.0.0.jar
-- intersystems-uima-1.0.0.jar
-- intersystems-utils-3.1.0.jar
-- intersystems-xep-3.1.0.jar

I have the jar files, but where can I find them for download? Are they available on a maven repository somewhere?

Any help would be appreciated!

Hi Community,

On 8-9 June 2020 InterSystems UK & Ireland will be hosting the annual events for its customers, offering both technical and strategic insight content on the different ways to achieve successful digital innovation:

➡️ InterSystems UKI Developer MeetUp

➡️ InterSystems UKI Innovation Day

InterSystems is committed to your success, and to ensure we make the best use of your valuable time, we would like to understand more about the technology drivers and challenges your business is facing now, and how you are preparing beyond 2020.

With your help, we can ensure that the conference agenda features topics relevant to your business, with information that will maximize your IT investment and partnership with InterSystems.

The survey will only take an estimated 3 minutes to complete. Thank you in advance for your feedback!

SAVE THE DATE

Keep your eyes peeled for an official event invitation in coming weeks, but you can save the date and register your interest here.

Hi,

Do you have any experience in server side pagination with IRIS using Angular on the client side?
Any idea on a typical SQL request on the server side?

Thanks!
Blaise

Hi Everyone,

I've been working on deploying an IRIS for Health environment in EKS. There is a video session in the InterSystems learning portal about this feature but I have not succeeded in finding the proper documentation and resources to use this in my Kubernetes cluster.

Has this been deprecated/discontinued? Any idea where can I find the resources? Should I stick to StatefulSets instead of using the IrisCluster resource type provided by this operator?

This error is sometimes seen while viewing a listing in InterSystems IRIS Business Intelligence:
ERROR #5540: SQLCODE: -99 Message: User <USERNAME> is not privileged for the operation (4)

As the error suggests, this is due to a permission error. To figure out which permissions are missing/needed, we can take a look at the SQL query that is generated. We will use a query from SAMPLES as an example.

Hi,

I have a production with a BS calling a BP calling another BP and so on and finally a BO. All calls are made using SendRequestSync.

The initial request is passed by value. The response is passed by ref and I allocate memory for it in the BO, hoping that it will go back to the initial caller in the BS, but it does not.

It looks like the following:

Hi,

I created a BS with a SQL Inbound Adapter.

Query = "SELECT rowid, fname ,lname,datesent
FROM labs
WHERE datesent IS NOT NULL"

DeleteQuery = " update labs set datesent = Getdate() where rowid = ?"

KeyFieldName = "rowid"

i am getting the following errors.

"NOT assuming network disconnect error based on: Gateway failed: DropStatement."

"Skipping previously errored row '235'"