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 seen in the past that file streams write fast at the start. As the file continues to grow, the process' memory usage increases until it reaches the max allowed.

Hi folks!

Here is how I grant SQL access of user to a particular class/table:

GRANT SELECT, UPDATE ON Packacge_X.Table_Y TO UserZ

How can I grant SQL access of a certain user to a whole schema?

Hello,

I need to create a dialogbox  on my zenpage to confirm a Delete operation. 

I tried using below code on in a my client side method but its creating a blank dialog box.

zenLaunchPopupWindow('%ZEN.Dialog.confirmationDialog.cls','confirmationDialog','resizable,width=380,height=180');

Is there a way i can create a Dialog box with text "Do you want to delete" and two buttons "Yes" and "No" and store the response in the calling client/server method.

Thanks,

Jimmy Christian.

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

Please suggest or share the steps for the  same document if any for the same, that will be really helpful, Thanks

Regards

RS

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Automating InterSystems IRIS Instances Configuration

We’ve published an update to the Serenji debug extension for Visual Studio Code, making it ready for the Workplace Trust feature in VS Code 1.57.

This allows the Serenji ObjectScript editor to work without restrictions across all workspaces and, by bringing it in line with the VS Code update, only allows the debugging feature to be used in trusted workspaces.

Hi Developers, 

It's time to announce the Winners for May 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in May 2021:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈  @Guilherme Koerber, Programmer, Bplus Tecnologia, Brazil

Learn more about the competition and our awesome winners below.

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.

Class JSON.

Hi Developers, 

We invite you to take a few minutes and leave a review about your experience with InterSystems IRIS on the TrustRadius. Submitting a review requires time and effort, so we'll be glad to reward you with a $25 VISA Gift Card for a published review!  
UPDATE: this promotion ended in 2021. 

Hello, first of all thanks for your time reading this question and thank you for your replies

We would need some help

We are trying to create a function to generate a random number with always 4 digits

We have already read the following topics:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

https://community.intersystems.com/post/how-generate-random-string-fixe…

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…

How would you recommend to write a function to handle this use case?

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? 

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

Some key points are emphasized in this article in order to save your time to get linux ldap client in cache working with windows AD (active directory) LDAP server. The first thing to do is to get successful TLS connection to windows AD. Raw tcp case is beyond of this article, there is no problem with it, it is trivial. Windows ldap server uses port 636 for tls and this port can be used to get ldap certificate. As we will see later there is reason for this. linux ldap client uses STARTTLS special ldap extension to switch plain tcp to TLS only.
Hence, connection should use port 389.

I'm looking for a way to get the message header ID for the current message in a Request to a Business Process.

I've located some code that gives me what I need, but it runs the risk of violating the "abstraction layer" ISC has in place around such things. And while I very much appreciate their efforts at keeping things simple for me ... well, sometimes you just have to dig through the guts to get what you want.

Is there a documented, deprecation-resistant method for getting at %Ensemble("%Process").%PrimaryRequestHeader.%Id() from within a  BP?

Gartner defined DataOps as: "A collaborative data management practice focused on improving the communication, integration and automation of data flows between data managers and data consumers across an organization. The goal of DataOps is to deliver value faster by creating predictable delivery and change management of data, data models and related artifacts. DataOps uses technology to automate the design, deployment and management of data delivery with appropriate levels of governance, and it uses metadata to improve the usability and value of data in a dynamic environment.

A concurrent session in IRIS:
SQL, Objects, REST, and GraphQL
 

Kazimir Malevich, "Athletes" (1932)
 

"But of course you don't understand! How can a person who has always traveled in a horse-drawn carriage understand the feelings and impressions of the express traveler or the pilot in the air?"

Kazimir Malevich (1916)

Introduction

We’ve already addressed the topic of why object/type representation is superior to SQL for implementing subject area models. And those conclusions and facts are as true now as they have ever been. So why should we take a step back and discuss technologies that drag abstractions back to the global level, where they had been in the pre-object and pre-type era? Why should we encourage the use of spaghetti code, which results in bugs that are hard to track down, and which relies only on virtuoso developer skills? 

There are several arguments in favor of transmitting data via SQL/REST/GraphQL-based APIs as opposed to representing them as types/objects:

Hi Community,

Please welcome the new video from #VSummit20:

⏯ Special Sauce: InterSystems IRIS Overview

Is there a call in ZEN to FOP to combine (merge) separate PDF documents into one?

Or does anyone know of a Windows server program that could be called from Cache to do this.

Thank you in advance.

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.

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:

Hey Developers,

The InterSystems FHIR Accelerator contest is over. And now it's time to announce the winners! 

Are you excited?

A storm of applause goes to these developers and their applications:

(2021.1.0 isn't an option in the Product dropdown, but that's the version of HS I'm asking about!)

In the past I've used HS.Util.Installer.InstallBusDemo() to set up a local HealthShare environment (registry, edges, access gateway, etc.)  I don't see an equivalent in HealthShare 2021.1.  I tried importing the bits and pieces from a lower version but always seem to be missing something.  Is there an equivalent utility to do a local setup in HS 2021.1?

Thanks,

Lori

Difference between DO and JOB command and practical use of job in objectscript??

Hey Developers,

We decided to extend the registration period for the InterSystems FHIR Accelerator Programming Contest and voting will start only on Thursday, June 3! The voting period will last until Sunday, June 6.

So, don't forget to support the best solutions built using the InterSystems IRIS FHIR Accelerator Service (FHIRaaS) on AWS.

➡️ Vote here from June 3rd to June 6th!

How to vote and what's new?

Google has one intersting tool named Data Studio. This tool allows creating some interactive dashboards, based on your data, available from the internet. It already offers hundreds of connectors to any sort of data developed by the community. As well as some amount of community developed visualizing. And most importantly, Google offers a way to develop your own connector to your data. 

FHIRaaS provides a REST API, and it's available from the internet. So I've decided to try to create some basic report on data stored there. And in the end, I got this.

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

In the first article, a simple tutorial helped you to set up your FHIRaaS deployment.

Now, let's move forward and introduce a JS library to access the FHIR resource.

In the end, two examples of usage of this library will be presented, exploring the Appointment FHIR resource type.

SMART on FHIR JavaScript Library

FHIR is a REST API, so you can use any HTTP client in order to use it. But, it’s always a good idea to have help.

Furthermore, there is a cool initiative called SMART which aims to provide standards for easy access to health data stored over health systems.

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.

Finally, some features of the iris-on-fhir application are shown in separted articles. You can check out the full code at the application’s github repository.

I'm probably missing something really basic here -

• I spun up a copy of the Iris community edition AMI.  
• Added Objectscript extension to vscode
• Added objectscript extension pack to vscode
• Added server manager to vscode
• Connected to iris AWS instance using PuTTY
• Changed password
• in vscode, I used server tool to add the server

It seems to connect OK; I can see the %SYS and USER namespaces.  I clicked the "edit code in namespace" button and created a bit of hello world code.  However, when I try to save it, I get "failed to save file 'filename.mac' on the server.

Is there a way to add/substract from a pivot variable?

I have this MDX:

SELECT
  NON EMPTY [DateOfSale].[Actual].[YearSold].&[$variable.Year] ON 0,
  NON EMPTY [Product].[P1].[Product Name].Members ON 1
FROM [HOLEFOODS]

And with pivot variable Year equal to, say, 2016 it works:

Now I want to add previous year  first with one pivot variable and one explicit reference. It also works:

SELECT
  NON EMPTY
  {
    [DateOfSale].[Actual].[YearSold].&[$variable.Year],
    [DateOfSale].[Actual].[YearSold].&[2015]
  } ON 0,
  NON EMPTY [Product].[P1].[Product Name].