Please let know how to invoke a java program from intersystems. Also let know how to expose / consume webservices / APIs from intersystems

Is it possible to add quotations " " so that it is part of the output?

For example:

set b = "Cat"

Set c = b

w c giving an output of "Cat" as opposed to Cat.

InterSystems IRIS 2022.2 has Native SDK for Python (https://docs.intersystems.com/iris20222/csp/docbook/Doc.View.cls?KEY=PAG...).

We know how to traverse a global data structure using IRIS Object Script $Order function.

I am trying get the Unix time stamp in milliseconds

set epochSecond= $ZDATETIME($ZTIMESTAMP,-2)*1000

but the result is not accurate as $ZDATETIME ignoring /truncating the fraction of the seconds and the milliseconds calculation is not accurate with fraction seconds

for example

set epochSecond= $ZDATETIME($ZTIMESTAMP,-2)

1675830682

when its converts to the milliseconds

it became 1675830682000. not the accurate fractional seconds.

My target system looking for the milliseconds time stamp to authenticate.

InterSystems is pleased to announce the release of System Alerting & Monitoring (SAM) version 2.0.

Hi Guys,

I'm using the below to export a query result to excel file and the only file type is .csv (100) but the resulting has two problems,

first the row header is including the field type and second the resulting file is a tab delimited so columns aren't properly separated (see attached below)

set st = ##class(%SQL.Statement).%New(2,"Sample")
set sql = "select ID, name from MyClass"
do st.%Prepare(.sql)
set type="csv"
set rs = st.%Execute()
do rs.%DisplayFormatted(type,"C:\Temp\report")

Is there any chance to make available a arm64/aarch64 binary version for Caché ODBC Driver?

Just like IRIS ftp://ftp.intersystems.com/pub/iris/odbc//2021/ODBC-2021.1.0.215.0-lnxrh...

As I am using docker, currently is not possible to build locally a new image using existing Caché ODBC Drivers on Mac M1.

Have you ever seen those vaccum compressed towels, that look like a pill and after you add water became a towel?

That's our challenge for today. As usual shortest solution wins.

Task

You will receive an integer number and you will return a new number where each digit is repeated a number of times equals to its value.

Input:

42

Output:

444422

Note:

Introduction

Despite the fact that InterSystems has long recommended using external backup tools, many users have opted to use the internal Online Backup facility, which is included in all distributions of InterSystems products (IRIS Data Platform, Caché, etc.). The reasons why are quite obvious:

I wish to retrieve all the setting values for a given production. I have found

Well my last post got cut off for some reason. I am trying the new beta and wondering about the following functionality from Studio that I don't find in Atelier:

F12 = Open the routine and jump to the tag of the current call the cursor is on in a routine

F2 / <Ctrl> F2 = jumping to a bookmark / toggling a bookmark

<Ctrl> G = Jump to a tag in the code

When might these things be in Atelier? I use them a lot in Studio and the absence of these really slows me down.

Hi,

Cache Studio's inspector window can show me a Cache class's properties,methods parameters, XDATA blocks, Triggers, Foreign Keys, Queries and more, in a table in the Inspector window. Additionally, for properties, where the property accepts parameters, these parameters are listed together with possible value choices.

There are still so many syntax highlighting errors in Atelier, which still exists from first beta public release.

Dear Community,

We'd like to take this opportunity to congratulate you on the upcoming 🎄 Festive Season 🎄and wish you a joyful holiday season filled with the warmth of 🧑‍🏫 shared knowledge, 🫂 the camaraderie of fellow members, and the anticipation of 🧑‍💻 exciting projects and contests in the coming year!