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.

I have created a custom role in IRIS for users to provide limited view-only access for querying tables in the HSANALYTICS namespace. WinSQL has been installed on a Windows server (WinSQL Lite version 14.0.244.784) and an ODBC connection entry has been created in WinSQL for the users to log in and run SQL queries. The custom role provides the roles/resources included in the attached file. The WinSQL System DSN entry defined is:

Health Insight UAT HSANALYTICS 64-bit InterSystems ODBC35

The ODBC35 driver is defined as:

Found one interesting behaviour in one system with Ensemble. Some Request class has a property with type %XML.CharacterStream by design, this class is the heaviest request in the system, and with profiling journal files, it got about 40% of the file. When I counted all the sizes of such streams per one day and found that the real stored data is three times less.

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

Hi all, I am new to IS Objectscript and I would appreciate some assistance regarding this.

I am trying to find out how to count the number of elements within a dynamic abstract object and I am having some trouble using the size method.

Here is the code below:

The key value pairs are originally in JSON and I would have converted it in to an object for use.

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems FHIR Accelerator contest!

Date & Time: Friday, June 11, 2021 – 11:00 EDT

What awaits you at this Virtual Meetup?

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

https://www.youtube.com/embed/K2fJ7L5LEno
[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 Guys,

I'm wondering how can I get fields defined as %GlobalCharacterStream diplayed in a SQL query or even objects?

I've some data that I need to convert over to a new system and the old uses %GlobalCharacterStream data type for one of its fields and I''m unable to display or extract to a spreadsheet, any help pls?

thanks

Getting this error:

ERROR <Ens>ErrFTPPutFailed: FTP: Failed to Put file 'TestsDaily.xlsx.xlsx'
(msg='Error in SFTP Put('\\Reporting\reports\Daily-Weekly\TestsDaily\To Be Processed\TestsDaily.xlsx','/TestsDaily.xlsx.xlsx')
ERROR #7500: SSH Put Error '-2147024894': The system cannot find the file specified. [80070002]',code=0)

is this due to the file extension? Also, if its just because the file isn't there, how to fix that?

Are there any direct command to find the length of subscript of global variable? Is it possible to code in objectscript to find the maximum length of subscript in a global variable.

We are pleased to announce that now you can choose the preferred language of the Global Masters program! Available languages: English, Spanish, Portuguese, Japanese, Chinese.

Choose the language in your profile settings:

Hi,

is it possible to avoid the display of certain properties in a custom message class in the message viewer content section. The message class is a common Ens.Request with a bunch of properties alongside one property of Type enslib.dicom.document wich in Turn is Not extended By %XML.Adaptor so the content display of course displays an error.

My idea is to avoid the display of That certain property When output is rendered (Text/XML). Using Ens.Util.MessageBodyMethods and method %OnShowContents could be a way to do this But i don‘t find a way to do so.

Hello Respected members,

I am new with InterSystems IRIS , want to setup the environment on RHEL 7.5 with multiple lun layouts (separate LVM for DB , Journal, and WIJ),

I would like to get some help in setting up the same, as far as I know, the installation will go through on a single directory ( I did not see any option to chose path/directory for DB's or WIJ /journals), hence after installation I would like to move my DB's to separate LVM and WIJ on another LVM set

Hi guys,

It's FHIR contest and this time, they provided something really cool: FHIRaaS

And to be part of this, @José Pereira and I team up (again) to deliver something easy to use and easy to understand how we did.

Introduction

This article aims to provide an overview of InterSystems IRIS FHIR Accelerator Service (FHIRaaS) driven by the implementation of application iris-on-fhir, available in OEX developed for the FHIRaaS contest.

A basic tutorial will guide you in configuring a function FHIRaaS deployment, including an API key and an OAuth 2.0 server.

A library to use FHIR resources through FHIRaaS also is briefly discussed.