All time

Parallel query hinting boosts certain query performances on multi-processor systems via parallel processing. The SQL optimizer determines when this is beneficial. On single-processor systems, this hint has no effect.

Parallel processing can be managed by:

  1. Setting the auto parallel option system-wide.
  2. Using the %PARALLEL keyword in the FROM clause of specific queries.

%PARALLEL is ignored when it applied to:

11 0
4 248
InterSystems Developer Community is a community of 25,124 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Here at InterSystems, we often deal with massive datasets of structured data. It’s not uncommon to see customers with tables spanning >100 fields and >1 billion rows, each table totaling hundred of GB of data. Now imagine joining two or three of these tables together, with a schema that wasn’t optimized for this specific use case. Just for fun, let’s say you have 10 years worth of EMR data from 20 different hospitals across your state, and you’ve been tasked with finding….

7 1
3 228

I want to integrate IRIS with Keycloak OAuth2 provider to use delegated authentication everywhere and to secure everything - sys*/Portal applications, REST services, FHIR server and so on. If an unathenticated user tries to access any IRIS URL - he or she should be redirected to Keycloak. After the user has successfully authenticated, i would like to access his requistes (username, email, roles, scopes) extracted from the JWT token, programmatically. What should be done to achieve that?

1 1
0 247

Hi Developers!

Here are the technology bonuses for the InterSystems Python Contest 2024 that will give you extra points in the voting:

  • IRIS Vector Search usage - 3
  • Python Pex Interoperability - 3
  • Python in BPL - 2
  • WSGI Web Apps - 2
  • Python libs: sqlalchemy and dbt - 2
  • LLM AI or LangChain usage: Chat GPT, Bard and others - 3
  • NoObjectScriptLine - 3
  • Hugginface - 2
  • Docker container usage - 2
  • ZPM Package deployment - 2
  • Online Demo - 2
  • Implement InterSystems Community Idea - 4
  • Find a bug in Embedded Python - 2
  • First Article on Developer Community - 2
  • Second Article On DC - 1
  • First Time Contribution - 3
  • Video on YouTube - 3
  • YouTube Short - 1

See the details below.<--break->

1 0
0 248

I am actually new to IRIS, and we are DevOps/PowerShell/Ansible team. We want to achieve certain administration tasks like updating Memory, Heap size, Lock size etc., in Management Portal through PowerShell. Is there any way i can achieve this without out logging in into Management portal. Off course, we have namespace, user id and password details. We have installed ODBC drive and able to update tables in the IRIS database.

0 4
1 244

Is it planned that LOAD DATA takes into account several DATE/DATETIME formats with, for example, a parameter indicating the format used in the source data?

example :

LOAD DATA .../...
USING
{
  "from": {
    "file": {
       "dateformat": "DD/MM/YYYY"
    }
  }
}
2 3
0 245

Why to use it

This app offers an easy interface to analyze storage:

  • Filter by database (namespace), global name, used size, or allocated size;
  • View a sum of the used and allocated sizes for the filters applied;
  • Export the table to JSON, CSV, or XML.

How to use it

Follow the instructions on the README file from the GitHub repository, and configure the settings to connect to your instance.

5 0
1 248

Hello Community,

Watch this video to learn how to add a condition to a single command without using an If statement.

Controlling Command Flow with Postconditional Expressions

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

2 1
0 228

I have a pResponse output in my onrequest method, in here I build an ACK and set the pResponse variable to it, and return a status object afterwards.

The pResponse doesn't show up in the trace or message viewer, yet if I move the interface to another more established namespace it works fine, what settings or config could be preventing the ACKS going back?

0 4
0 244

Hi All! Wanted to share a recent video we released, for those of you who may be getting started with InterSystems HealthShare Health Connect Cloud. This video walks through all the management tasks you can complete via the InterSystems Cloud Services Portal that you use with Health Connect Cloud. Feel free to reach out if you have questions!

2 0
0 248

Hi Friends ,

We have requirement to load data into chache tables from external database (ref data). This process will take 1 min to complete all data load.

Currently I have created Business Service to trigger Business Operation with out bound db adapter to load data into cache tables.

process will be trigger when i restarted business service.

But requirement is , this business service should be triggered from outside ensemble environment i.e , this should expose as REST endpoint and share with the external team.

0 1
0 247

Save the date! March 16th, 9 am EST | 2 pm CET we will host the first Thursday Tea with Global Masters!

This is a 60-min fun & networking event, as well as a short update and Q&A about the Global Masters program.

>> Please prepare a short 1-2 min presentation about yourself for this event - even better with some pictures 📷 we will also make 5-min breakout rooms to discuss your favorite hobby.

RSVP in this challenge on Global Masters.

0 0
0 248

Hey Community!

We've always had this idea on the back burner about improving the process of collecting, analyzing, and responding to product enhancement requests from our members. We knew we needed a good user experience and even better internal processes to make sure the best ideas were gathered, heard, and responded to. And finally, this thought has come to fruition!

So in case you missed it, let me introduce to you the Official InterSystems feedback portal:

💡 >> InterSystems Ideas << 💡

2 0
1 248

Hi all,

I am looking for a best practise approach for providing an ITI-41 based webservice to allow a subsystem to send a provide and register document set transaction via webservice route the request to a registry and loop back the response from the repository to the originating service. Since we need to use Ensemb le 2017.2 I am looking for a best practise to takle that reuirement. As for health connect I could prove a webservice wich supports the named IHE transaction and route it to the registry quite simple. Anyway how would you cope with this requirement under Ensemble?

0 1
0 247
Question
· Mar 22, 2022
Time handling and Json

I am having trouble formatting %Time to a JSON format. I have tried configuring the parameter "FORMAT" of my property but that didn't work. For some reason, it keeps putting a Z and the end of the time.

Property:

Property TimeCollected As %Time(FORMAT = "2");

0 2
0 246
Question
· Nov 20, 2020
validate logon

When I log in to the management portal page, I want to know where to verify whether the user name and password information I entered are correct, and how to handle it in the program. Is it handled through routine? Or is there a Dispatch Class to handle?

1 1
0 247
Question
· Jan 26, 2022
usage of the ^STMONITS global

I am working with a client database that is growing exceptionally fast ( about 15G/day). As I understand it, the usage of the global ^STMONITS to gather statistics can consume a large amount of database space. This client in question is using this global. I would like to determine of the 1.7T size of the database, how much is being consumed with statistics data by the usage of the ^STMONITS global. Is there a method to get this value whether a size or percentage of the database overall size.

0 2
0 246

Hello community,

It would be appreciated if you could read and respond to us:

➡️ We need to activate a SOAP Operation during a time slot, in order to send messages to the target system, only for a few hours; for example from 4am to 8am.

The requirement is to do this without a scheduled task. This is because when changing nodes, in the production mirrors, there are difficulties, challenges, or issues with scheduled tasks.

0 2
0 246

I am writing a report for a client that will create a report of the current process with a format that mimicks the Management Portal process display. I am writing a cterm script file to generate the report.

In the loop that process the results I am writing the columns in a formatted manner that will result in a CSV format very similar in content and order the process page. However, it appears that the write statement is limited in size such that I can not write out all of the elements of the sys.process query. My query result processing that works correctly is of this format:

0 4
0 244

Hey Developers,

Please welcome the new video by @sween on InterSystems Developers YouTube:

Hands Off HealthShare Deployment Workflow with GitLab Runners

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

Gitlab Runners and InterSystems Healthshare Code Deployment and VSCode oh my. More details in this post.

2 1
0 228
Question
· Sep 13, 2021
RDP ODBC Connection Issue

Interesting issue we found. When making an ODBC connection from a host via RDP, the IP address shown as making the connection is the client IP address, not the host from where the connection initiated. Has anyone seen that or know how to get around it?

Example:

My Computer(10.X.X.112) -> RDP to Host1(10.X.X.93) -> ODBC connection to Server1(10.X.X.12). Cache Portal -> System -> License Usage -> Usage by User shows My Computer's IP address as making the connection rather than Host1.

0 2
0 246

Reference: sample LDAP code routine LDAP.mac

Some IF statements reference macro $$$WindowsCacheClient as a boolean flag to mark if the client calling the LDAP server is running Windows. Other IF statements reference $$$ISWINDOWS. Are they not the same thing? That is, does the routine need $$$WindowsCacheClient at all?

Examples:

#define WindowsCacheClient 1

0 2
0 246
4 0
0 248

I like to be able to call an "autohotkey" executable message box from within a running Cache routine executing as a jobbed routine. The autohotkey executable displays a small pop-up window with a message and an "OK" button .. and will time out in 10 seconds if the user does not press the OK button.

Although $ZF(-1,cmd) executes (where "cmd" contains a simple batch command e.g. @c:\autohotkey\warning.exe), no interactive window appears and, once the autohotkey routine times out, the calling cache routine simply continues.

0 5
0 243

Hi Community,

2019 was a great year full of video content for InterSystems Developers. Already 200 Videos on our InterSystems Developers YouTube Channel, and the number of subscribers has doubled since the previous year!

Almost 57K Views and 5,1K hours of Watch Time in 2019! Thank you, our dear subscribers, so we understand that our video channel is valuable to you!

Now let's take a closer look at the most popular videos on InterSystems Data Platforms over the past year.

2 0
1 248