I am exporting data from Cache using the SQL export wizard. This is on a docker image of Cache hosted on a Linux server.

I select my database, schema, and table, make sure that all columns are being exported, check other settings, and then finish the export.

All server settings look correct and permissions are rwe on the directory. I have tried various directories, including a system level directory. I tried creating the file before I do the export in case there was an issue with creating the files, and I also made sure the created files had rwe permisisons.

We're excited to announce a new version release of the SQLTools VS Code extension.

SQLTools connects VS Code users to the most commonly used databases using drivers, including InterSystems IRIS. With over 3.5 million downloads, it is helping users work with their data much more easily.

What's your approach to learning InterSystems technologies?

Elevate your learning journey with us: share your insights in a brief survey and help us shape your learning experience.

Hi,

I would create a custom ASTM schema. Where can we find any existing ASTM schema file?

Any advice?

William

I noticed that the XCPD processor has a setting for PDQ minimum threshold and maximum record count returned, but PDQ does not have these settings. Can anyone explain why? They are essentially the same service.

Hello all,

If we have a global structured something like this:-

Hi Community,

Watch the latest video on InterSystems Developers YouTube:

⏯ Understanding the Structure of HL7 FHIR Resources

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

Hey Developers,

Please welcome a new set of Global Masters badges for 💡Tech Quizzes on InterSystems Global Masters!

From now on, each of your suggested and approved Quiz Questions will not only enhance the fun and challenge all Global Masters members but will also earn you badges and recognition.

Hi Community,

Watch this video to learn how to use the GitUI plugin in the HealthShare Health Connect Cloud user interface to make changes to your interfaces in the Management Portal and commit them directly to your source control workflow.

⏯ Using UI Based Source Control for Health Connect Cloud

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

Hi Developers,
Let's meet in-person at our next Developer Meetup in Boston on March 27 5:30 pm!
>> RSVP here <<

I have been struggling with a docker run command that kept crashing, the error message was too generic to point me to the right direction.

Since the container is shut down after the failure, I was unable to login to it in order to figure out the problem.

I had to run the container in a way that I'll be able to log into it before it crashed, so I found the adding -u false prevents the docker run command to run the iris session IRIS and the container stayed up and running. then I was able to log into it using:

Hi Developers,

Thank you so much for being a part of the InterSystems Developer Community Ecosystem for yet another year!

We love that you participate in the life of the Developer Community, Open Exchange, Global Masters, and Ideas Portal.

We'd like to know how useful are our portals for you at this point. Please take a few moments to let us know what you think and what could be improved:

👉 InterSystems Developer Ecosystem Annual Survey 2023 👈

Note: The survey will take less than 10 minutes to complete.

Hi Guys,

I never ran a Compact & truncate process before and we do have a 4.6TB database with 1.9TB free space available that I would like to recover

We are using the IRIS cloud. and I am working on a DTL .

so the source side timestamp is local time for example 20240110134740, I know it is a local time. so the requirement is I need to append the UTC at the end, like -0400 or -0500 depending on if it is daylight saving time.

so is there function to return if current day is at daylight saving time, so I can decide if I need to append the -400 or -500? or a function to return the current UTC by location?