Howdy all,

I'm very new to intersystems, therefore I'm seeing some suggestions here.
My query - I'd like to setup monitoring for IRIS local database size monitoring using SolarWinds. Preferably, using REST API connections, could someone help with this. Thank you in advance.

Hello Community,

I'm executing the same query with same column name but in different case. An unique cached query generated while query executed first time. The query preparser only normalize the keywords and send to the SQL engine generates the Hash. Eventually use the cached query next use.

Now my question, The hash values are same for both of the queries. Then why it creates two cached queries.

Query1: select * from MyLearn.Test where Name['Kev1'

Query2: select * from MyLearn.Test where NamE['Kev1'

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in April 2021:

Hello,

as it took me some time to figure out what's wrong, I would like to share this experience, so that you do not fall into the same trap.

I've just noticed that if you name your package "code" (all lowercase), in a class using some embedded python using [Language = python], you'll face the <THROW> *%Exception.PythonException <PYTHON EXCEPTION> 246 <class 'ModuleNotFoundError'>: No module named 'code.basics'; 'code' is not a package

I need read only access using a JDBC query to the tables that contain the rules data for a particular interface. I'm having difficulty locating the tables that house the rule data and I'm wondering if someone could help me with that information and any sample queries if possible.

Thanks in advance!

Where is InterSystems IRIS Download for Windows (better free)?

Hello, community.

I have a problem with running a SQL query on a linked MySQL table.

The connection works fine, but the following query throws an error:

SELECT TOP 10 * FROM linkedinternal_test.persons

[SQLCODE: <-400>:<Fatal error occurred>]

I am attempting to create a Foreign Server/Table so I can pull some information in from MS SQL server via JDBC connection, but as soon as I create the Server/Table and logout the Foreign Server disappears.

CREATE FOREIGN SERVER Epic.Clarity 
   FOREIGN DATA WRAPPER JDBC CONNECTION 'MS-EpicClarity'

logout, then run

Hi we are migrating to Linux from OpenVMS. which includes a new server and SAN. after reading a prior post about the differences with ESX and a VSAN I would think that the a SAN with Virtual disks all SSD type would be similar. which after reading it makes me think that using thick provisioning is the way to go. the 3rd party vendor is arguing this point with me. is it the same premise? is non-dedupe the way to go with thick provisioning. we are currently on 2015.2 of Cache with the plans to go to 2018 until the app vendor is able to certify their product on the latest versin.

Hi Developers,

Watch this video to learn how UC Davis Health is implementing a centralized operations-monitoring and alerting framework to handle notifications across its InterSystems IRIS infrastructure using ServiceNow, an IT service management platform:

⏯ Advanced Integration Monitoring & Alerting at UC Davis Interfaced with ServiceNow @ Global Summit 2023

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

Can you please provide the package for adding new column in the FHIR table using additional package for the boolean datatype.

1) Package.JSON

2) SearchParameter.JSON

3) StructureDefination.JSON

Please provide all the code for all three file for boolean datatype.

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "ObjectScript - Persistence and Integration"!

Date & Time: July 19, 4:00 PM (CEST)

Speaker: @David Reche, Manager of the Dev Community in Spanish

Hi Team,

I’m looking for an API or command to determine if the supported CPU version exists on a Windows system.

Before installing IRIS, I would like to confirm whether the system/server has the supported CPU version. Do we have any API or command to check the details before starting the installation of IRIS 2024.1?