Is there any way to execute many SQL commands at once as an (anonymous)block?

for example in PostgreSQL there is

DO $$

BEGIN

--here is Inserts/Updates/Deletes

END $$

Or in Oracle

BEGIN

END; 

Thanks for the answers!

Hello,

We need to create a versioning of an existing API, so we going to set a default version (so far) for current connections to version 1

My first attempt is:

Hi guys,

I'm trying to immigrate some of my HealthInsight dashboards and pivot tables to another HS instance.

In some pivot tables, I defined them with a set of calculated dimensions defined in the analyzer, e.g as below:

Then when I exported the cubes and pivot tables in used to my new envirmonment. When I open my pivot tables again, the calculated dimensions are missing and hence my pivot tables no longer work:

I'm working on an existing Zen Report that uses queryClass/queryName to retrieve data using a class that has a Stored Procedure method. Which works fine.
I have created second class with a Stored Procedure method, I modified the zen report to use this class and now I'm having the following error.

Error: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation
ErrorNo: 5540

Regards,

Rui

We had a major problem recently where a participant was sending unexpected data. It was not enough to throw an error or warning in the actual trace, but when examining the message in the viewer it did show the following:

Build Map Status = 'ERROR <EnsEDI>ErrMapSegUnrecog: Unrecognized Segment 4:'CON' found after segment 3 (CON)'

How can I query for these or be notified of them? This caused major ramifications but we did not notice it. I have Managed Services investigating but I want to cover all my bases.

Hi Developers!

Welcome to Issue 10 of the InterSystems Ideas newsletter! Here's what you can expect from it:

​​​​✓ Month of ideas about "FHIR and Digital Health Interoperability"

✓ Reached 300 ideas on the Ideas Portal 🎉

✓ Recently implemented ideas

Hi Guys,

Is there a sample on how to send notifications via sms ? do we need an smtp sever or a external plugin in..etc?

Thanks

In March'22 you may have seen an invitation to
Share a Demo of Your Open Exchange Application
The service behind it - InterSystems Online Demo Server (ODS) - is not something new

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

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

We would need help.

We have used the following commands:

set fecha = "2021-08-18T07:44:14.180+0000"

set nuevaFecha = ##class(Ens.Util.Time).ConvertDateTime(fecha,"%Y-%m-%d%T%H:%M:%S","%d/%m/%Y")

And when we write it to the terminal:

w nuevaFecha

It outputs nothing

Could you help us?

We have read:

hi, i am new to Studio and also new to objectscript, but i am not new to programming and

want to implement some synonymfunctions e.g. LOCATE should be used as InStr (.. like in much languages ;o)

more generally spoken, i want to implement a library for my string routines BUT of course i want an need autocomplete.

defining a macro $$$InStr does no autocomplete when i type $$$In<CTRL-SPACE>

example: my lib is called STRINGS and the functions are: InString, Split, ...

I managed to use CacheGlobalOrder to iterate over global and return the next subscript:

Hi,
I created a REST service that works well if called via VPN, for example the url http://192.168.10.60:57772/fm/status returns a JSON string as expected.
If I replace the ip 192.168.10.60 with the ip used for our public website nothing happens. If I remove the port :57772 the browser returns a 404 error page.
Do I have to use a different port or is this caused by the settings of our web server? (We are using Apache Web Server: Apache Cache_Server_Pages-Apache_Module/2016.1.0.656.0-1601.1554d)

What are the differenent format handles the data from Rest services?