I have a python script that is pulling the cache instance key expiration date ( KeyExpirationDate() ) which comes back as an integer. With the queryscript function - $ZDATE(73284) I can derive the actual expiration date. Is there a manner or method of creating an equivalent Python script that will convert the integer return by the KeyExpirationDate() method into a date string?

0 1
1 285
InterSystems Developer Community is a community of 23,519 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Does any one could tell me how can I access the target properties from inside SQL in DTL Subtransform? For example, if I use the following statement:

SELECT ID INTO :target.SetIDPID FROM firstlook.person WHERE FirstName = 'Paul' - as said in documentation :

  SELECT Name INTO :target.Name FROM MainFrame.EmployeeRecord WHERE SSN = :source.SSN AND City = :source.Home.City

I get an Error: ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>

0 1
0 338

Function as a service (FaaS) is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage application functionalities without the complexity of building and maintaining the infrastructure typically associated with developing and launching an app. Building an application following this model is one way of achieving a "serverless" architecture, and is typically used when building microservices applications.

Wikipedia

FaaS is an extremely popular approach to running workloads in the cloud, allowing developers to focus on writing code.

This article will show you how to deploy InterSystems IRIS methods in a FaaS way.

7 4
2 407

The Complex Recordmapper specify a map for headers, body, and trailers, but it expects all three to have fixed Leading Data to identify the record type. But what if the Header and Trailer have Leading Data, but not the body records? I can't seem to find a way to do this. For example:

HEADER|194|2012|Fall|20
12345|Adams|John|Michael|2|john.michael.adams@example.com|617-999-9999
12347|Jones|Robert|Alfred|1|bobby.jones@example.com|
TRAILER|8|100

Ideas?

1 2
0 343

Hi Community,

We'll look at moving InterSystems workload to the public cloud, then take a deep dive into the current architectures on the InterSystems cloud platform:

⏯ InterSystems Solutions in AWS

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

1 0
0 345

Welcome to the February'22 Community Release!

We're pleased to present our brand new Community Event Calendar for InterSystems developers:

🎯 https://community.intersystems.com/events

In this calendar, you will see the history of DC events. Find out about events that are happening now or soon, check out past events, and watch recordings of Community's webinars and meetups.

Let's take a closer look at how to use it.

6 2
0 306

Hey Community,

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

New Videos
№ Video Views
1 Using the VS Code Debugger for InterSystems ObjectScript 3378
2 Introduction to Cubes in Business Intelligence 349
3 Smart Data Services (Vision & Demo) 232
4 Join Us on a Journey from Caché/Ensemble to InterSystems IRIS 129
5 Using VS Code with Python 97
6 InterSystems Python Contest Kick-off Webinar 91
7 GlobalToJSON ePy 43
8 Securing FHIR Applications with OAuth 2.0 (Part 1) 31
9 GlobalToJson Embedded Python Pure 28
10 Creating Virtual Models with InterSystems IRIS Adaptive Analytics 27

2 0
0 189

This is the third part of the series of articles on migrating from the main databases on the market to InterSystems IRIS. In this part, the procedures for migrating from DB2 will be detailed.As described in previous articles, there are currently a few options to do the migration. However, the two most popular options include the usage of DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway.

2 0
1 594
Discussion
· Mar 4, 2022
Code Golf: Label Validation

New month, new code golf!

You will receive a string with a label code with numbers and letters.
Our challenge is to check if this code begins with 1, 2, or 3 and ends with A, B, C, S, or R.
It should return true(1) if so or return false(0) otherwise.
As usual shortest solution wins.

Input

"198739A79D9R"

Output

1

6 4
1 365

I am writing a Python tool to query our cache instances for various information. I have set up the connection without issue:

import intersys.pythonbind3 as pyb

conn = pyb.connection()
conn.connect_now(.....)

db = pyb.database(conn)
qry = pyb.query(db)
obj = pyb.object(db)

I wanted to make the call:

execRes = qry.prepare_class("SYS.Database",'FreeSpace')

But fetching fails because of data mismatches ( as I understand from other posts) and my testing bears out this type of failure.

0 6
0 239
Question
· Jun 9, 2017
Emergency Access

What is the purpose to use Emergency Access Mode in Cache? How to establishes a Connection without performing authentication?

0 6
0 1.7K

Hi Developers,
We are excited to announce that InterSystems will be a Platinum sponsor of Hacking Health Camp - big professional HealthTech conference and hackathon, which will take place in-person in Strasbourg, France on March 25-27, 2022.

On March 8, 2022 @Guillaume Rongier will carry out a webinar "How FHIR can help you develop your health applications" (Webinar language: French). Register here.

At the hackathon, InterSystems will have a challenge for hackers on using InterSystems FHIR cloud services.

Learn more on official website and join us in-person in France!

SUPINFO Hacking Health Camp

7 0
0 390

I want to have a script that can run from the usual unix, linux, or aix command line. It has to be able to get into an irissession and use set statements to get data using sql. It seems like I'm in a catch-22. When I use the irissession SERVER command at the command line, I can't run a script. When I put the irissession SERVER command in a script, it won't run anything in the script after that.

My goal for this script is to get this information and put it into a file which I can then parse.

0 10
0 2.6K

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems Python contest!

You'll have an opportunity to have a discussion with InterSystems Product Managers on the new IRIS 2021.2 Embedded Python functionality, Q&A on Python, etc. Our winners' demo included!

Date & Time: Thursday, March 3 – 10:00 EDT

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

1 1
0 302
Article
· Mar 4, 2022 4m read
How to become a time lord - Time travel

Time travel is like visiting Paris. You can't just read the guide, you have to throw yourself into it. Eat the food, use the wrong verbs, get double the charges, and end up kissing complete strangers.

The Doctor

We are now going to travel through time, that is, we are going to see future and past dates and how to calculate them in different formats. The TARDIS doesn't wait, take the controls and hold on tight.

Travel in TARDIS

8 5
0 540
Question
· Aug 24, 2021
ECP system ID

Hi,

I'm looking through some journal entries in the hope of finding the root source of an issue.
I was wondering if and how you can map a "ECP system id" to a server.

Any hints would be welcome

Best regards
Ivo

0 4
0 450

NOTE: we previously found an issue with the 2021.1.1.324.0 builds. The 2021.1.1 maintenance releases have been removed from the WRC and have been replaced with 2021.1.2.336.0 builds. 2021.1.2 containers will be available shortly.

Two new sets of maintenance releases are now available:

  • Caché 2018.1.6, Ensemble 2018.1.6, and HSAP 2018.1.6
  • InterSystems IRIS 2020.1.2, IRIS for Health 2020.1.2, and HealthShare Health Connect 2020.1.2

Installation kits and containers can be downloaded from the WRC Software Distribution site. Container images for the Enterprise Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the InterSystems Container Registry.

3 9
0 528

Hi,

I was playing around with the python binding for caché (2018.1.4) and I ran into some problems.

When executing the class query "List" from SYS.Database the pythonbind interface throws an exception, that seems to be caused by a mismatch of the defined SQL datatypes for this query and what is actually returned (or the lack of type conversion in the pythonbind interface).

Is this a known issue ? Are there solutions/workarounds for this,
Or is this a bug ?

The details:

0 4
0 566