Hi,

I have the requirement to dump large result sets into files. I am currently using %SQL.Statement and the result set created by it.

The DisplayFormatted is used to write a CSV. The query I used to test does not contain any filters, it is just a select * from a table with 16 million rows.
The file created is 2GB in size. The issue I have is that it takes 8 hours to create this file.

Hi Developers,

We're pleased to invite all the developers to the upcoming InterSystems Multi-model contest kick-off webinar! The topic of this webinar is dedicated to the Multi-model contest.

On this webinar, we will demonstrate the APIs for each data model in action.

Date & Time: Monday, January 11 — 10:00 AM EDT

Speakers:
🗣 @Benjamin De Boe, InterSystems Product Manager
🗣 @Bob Kuszewski, InterSystems Product Manager - Developer Experience
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hi:

I have the following method in a buisness operation that works on localhost but not on our server . I think it's how the firewall is set up but i was wondering if there is a known way around this. It can't correlate XML as it returns a "The browser did not send any authentication information" error. I tried adding in username and password to http request to no avail. We could do a c# proxy on a server but i'm wondering if there is a known way to fix this error within intersystems. As a developer we don't have too much control over our Intersystems TIE server.

Hi Developers!

Recently we introduced several new features to Open Exchange which I want to share with you:

1. Application releases simplified
2. Subscription rules update

See the details below.

Hi,

Newbie Question.

I have a Staging table i want to populate by running a Stored Procedure and then query the same table with some sort of SQL inbound Adapter.

is this possible or do i need to create a separate service for this?

Thanks

When compiling in 2018.1.2 using $system.OBJ.CompileAllNamespaces() I am seeing the following errors on some of our Record Maps.

Why i am receiving more than 20 SHDWCBLK process running background when i try to shadow 5 namespace ?

I have a global that defines the instance that Ensemble is running under. I want to use this as part of another Global so I don't have to hard code a path.

For Example

^OSUWMCInstance = "TestClin"

^OSUMCLDAP("LDAPKey") = "/ensemble/^OSUWMCInstance/mgr/LDAPKeyStore/"

Is this possible?

Thanks

Scott

Hi!

There is an option to introduce Named filters in Analyser and save it with the pivot.

How can I make the Named filter available in a dashboard?

Presenter: Ray Fucillo
Task: Provide high availability (HA) and disaster recovery (DR) in diverse architectures that demand high performance, including replication over long distances
Approach: Give examples of mirror architectures in disparate environments, including geographically separated systems. Discuss performance considerations and advances in InterSystems’ mirroring technology

In this session you will learn about deploying Mirroring to provide HA and DR in diverse architectures that demand high performance and throughput. Challenges and solutions to achieving high throughput will be covered along with mirror architectures that involve long distances and disparate environments.

Content related to this session, including slides, video and additional learning content can be found here.

Visual Studio Code releases new updates every month with new features and bug fixes, and the January 2025 release is now available.

Hey Community,

Watch this video to see how to connect to InterSystems Cloud Services from your .NET application using the InterSystems ADO.NET Managed Provider:

⏯ Connecting to InterSystems Cloud Services with .NET

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

looking into tenants I see this:

But on the main page, I have 2 deployments that I can work with !!

What is going on ??

Hello, good afternoon! (or good morning or good evening)

I was doing some very basic tests, based on the documentation, using Python in Studio.
I decided to call a python method through the Studio's own terminal as a demonstration, but the result was different from the terminal result:

Code: