Article Mihoko Iijima · Jun 8, 2023 1m read How to write SELECT ... FOR UPDATE InterSystems FAQ rubric Since SELECT ... FOR UPDATE is implemented in many RDBMS as a method of explicit row lock acquisition, I think there are many cases where this function is used. This syntax is not an error for InterSystems products, but it does not acquire row locks as expected. This article will show you how to achieve equivalent functionality. #SQL #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 4 0 0 278
Article Mihoko Iijima · May 11, 2023 2m read How to estimate backup size for online backup InterSystems FAQ rubric You can use the system routine ^DBSIZE to estimate the backup file size (see also Note 1). ^DBSIZE estimates the file size of full, cumulative, and differential backups of the databases selected in the database backup list. The database backup list is created from [System Administration] > [Configuration] > [Database Backup] > [Database Backup List] in the Management Portal. #Backup #Tips & Tricks #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 2 0 0 223
Article Mihoko Iijima · Apr 13, 2023 6m read Recovering an accidentally deleted global InterSystems FAQ rubric In this article, we will introduce how to deal with the situation: "I accidentally deleted a global!" #ObjectScript #System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 8 2 1 506
Article Mihoko Iijima · Apr 7, 2023 1m read How to get last updated ID in SQL? InterSystems FAQ rubric The ID of the last updated record can be obtained using the SQL function LAST_IDENTITY().* This function can be used with embedded SQL or ODBC but not with Dynamic SQL, SQL Shell, or the Management Portal's SQL interface. Here's an example of usage with simple Embedded SQL: #ODBC #SQL #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 4 2 0 1.3K
Article Mihoko Iijima · Mar 5, 2021 3m read [InterSystems IRIS for the First Time] Interoperability: Let's learn how it works This article is a continuation of this post. The purpose of this article is to explain how the Interoperability menu works for system integration. #Beginner #Interoperability #InterSystems IRIS #InterSystems IRIS for Health 2 1 0 857
Article Mihoko Iijima · Mar 5, 2021 6m read [InterSystems IRIS for the First Time] Interoperability: What a Production is This article is a continuation of this post. In the previous article, how the Interoperability menu works for system integration was explained. In this article, I would like to explain how to develop a system integration using the Interoperability menu. #Beginner #Interoperability #InterSystems IRIS #InterSystems IRIS for Health 2 0 0 579
Article Mihoko Iijima · Mar 5, 2021 4m read [InterSystems IRIS for the first time] Interoperability: Message This article is a follow-up to this post. In the previous article, [What is a Production?], we checked the production contents. We ran the sample code and checked the flowing messages' contents into the production on the Visual Trace page. #Beginner #Interoperability #InterSystems IRIS #InterSystems IRIS for Health 1 0 0 506
Article Mihoko Iijima · Mar 5, 2021 10m read [InterSystems IRIS for the First Time] Interoperability: Creating Components (Business Operation) This article is a continuation of this post. In the previous article, we reviewed how to create and define messages used to send and receive data between components. #Beginner #Business Operation #Interoperability #InterSystems IRIS #InterSystems IRIS for Health 3 0 0 822
Article Mihoko Iijima · Mar 5, 2021 7m read [InterSystems IRIS for the First Time] Interoperability: Creating Components (Business Process) This article is a continuation of this post. In the previous article, we discussed business operations' creation from the components required for system integration. #Beginner #Business Process (BPL) #Interoperability #InterSystems IRIS #InterSystems IRIS for Health 2 0 0 441
Article Mihoko Iijima · Mar 5, 2021 9m read [InterSystems IRIS for the First Time] Interoperability: Creating Components (Business Services) This article is a continuation of this post. In the previous article, we discussed the development of business processes, which are part of the components required for system integration and serve as a production coordinator. #Beginner #Business Service #Interoperability #REST API #InterSystems IRIS #InterSystems IRIS for Health 2 0 0 610
Article Mihoko Iijima · Feb 2, 2021 3m read [InterSystems IRIS for the First Time] Let’s use Interoperability Hello, everyone! InterSystems IRIS has a menu called Interoperability. It provides mechanisms to easily create system integrations (adapters, record maps, BPMs, data conversions, etc.) so different systems can be easily connected. #Beginner #Interoperability #REST API #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 8 1 2 798