#Caché

Those of you that worked already with ECP might know that it operates not only across
operating systems, processor technologies (big-little-endian), but also -with limits- across versions in C/E.
This cross-version feature also includes IRIS (verified for 2020.1) and C/E (2018.3)

Hello everyone, i want to have an InterSystems Caché Installation cache-2017.2.2.865.0-win_x64.exe

Thanks

I need a stored procedure where I can execute multiple delete from statements.

This will work to create a stored procedure, but when I add in other delete from, get error invalid sql statements when try to create

CREATE PROCEDURE DeleteSpecimenTwo
(IN Specno VARCHAR(50))
BEGIN
DELETE FROM PCONT WHERE PSPECNO = :Specno;
END;

This doesn't work

CREATE PROCEDURE DeleteSpecimenTwo
(IN Specno VARCHAR(50))
BEGIN
DELETE FROM PCONT WHERE PSPECNO = :Specno;

DELETE FROM PSPEC WHERE PSPECNO = :Specno;
END;

I need connect to cache2016 database by python to get some data, but I don' t know how to connect by python, did anyone know how to create connection？

If you can provide any python code, that will be better!

Hi,

Question about ZMIRROR routine.

I analyze a problem with the label NotifyBecomePrimary. It seems not performed after a switch.

After installing ZMIRROR routine in %SYS, is a restart required?
If It's required, It could be explain my problem.

Thank you.

Hello Everyone!

Following the example below i can download file only txt format, in other format(pdf,xls,rar) i have errors(can't open file),

So, how i will change code for download file in other format?

Thanks!

Over the years, I have found myself needing to create multiple HL7 messages based on a single inbound message. Usually these take the form of an order or result from a lab. Each time I have approached it, I have tried to start from scratch under the belief that the previous attempt could have been done better.

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Real-Life Experiences Migrating a Caché Application Portfolio to InterSystems IRIS @ Global Summit 2022

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

Hello, I am writing some cache code that will pick up a PDF file, Base64 encode the contents and then send on to a third party system within a Long String (via their API). I have been testing this and discovered that the PDFs do not open within the supplier system (I get an error saying that it hasn't been decoded correctly). I wanted to prove that the issue does not lie with the way that I have Base64 encoded it within Ensemble, and therefore as a test wanted to Encode the PDF stream, then decode the stream and write out to a new file.

InterSystems Supported Platforms Update Feb-2023

Welcome to the very first Supported Platforms Update! We often get questions about recent and upcoming changes to the list of platforms and frameworks that are supported by the InterSystems IRIS data platform. This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap.

We’re planning to publish this kind of update approximately every 3 months and then re-evaluate in a year. If you find this update useful, let us know! We’d also appreciate suggestions for how to make it better.

With that said, on to the update…

InterSystems has corrected an issue that can cause InterSystems IRIS® and Caché to not take advantage of large pages for shared memory on Windows, even though these products report that large pages are allocated. This can have detrimental effects on system performance.

Have a iris.dat file that was zipped in axis but , now I unzipped it and can see the file in my c drive but when I go to iris management console to perform a new db to pull in the current iris.dat file , in the wizard I do not see the iris.dat file listed.

Need some help with getting it restore the Cache backup in my iris community edition.

thank you,

Hi,

Can anyone please help me how to use regular expression/wild character on a sql query for a pattern like C00.0 to C00.9, C01.0 to C01.9 and so on until C77.0 to C77.9 .

Thanks for your help

Thanks

Jude

I would like to know how I can make a utility to retrieve all the names of properties of a class. Any idea?