Article Mihoko Iijima · Sep 21 1m read Description of each timeout value that can be set in the default parameter of Web gateway/CSP gateway management InterSystems FAQ rubric The meaning of each timeout value is as follows. 1. [Server response timeout] If IRIS/Caché processing (routine or query execution) does not finish within this set time, the browser will return an error. For example, if this value is 60 seconds and it takes 90 seconds to execute a routine/method/query, an error will occur. 2. [Queued request timeout] #CSP #REST API #Tips & Tricks #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 4 2 0 145
Announcement Mihoko Iijima · Sep 20 The 1st InterSystems Japan Technical Writing Contest! Hello developers! We are holding the first technical article contest on Japan's InterSystems Developer Community! The first contest is a technical document writing contest, and you can submit any content related to the InterSystems IRIS/InterSystems IRIS for Health. (The article must be in Japanese.) ✍ InterSystems Japan Technical Document Writing Contest: Articles related to IRIS ✍ 🎁 Participation prize: There will be a participation prize for everyone who submits an article for the contest. 🏆 Special prize: Authors of three selected works will receive special prizes. Entering the contest is easy! Please post an article related to IRIS on the developer community during the period from Wednesday, September 6, 2023 to Monday, November 6, 2023. #Contest #Events #InterSystems IRIS #InterSystems IRIS for Health #IRIS contest 6 0 0 140
Article Mihoko Iijima · Sep 14 1m read How to get all fields of a specified table with SQL InterSystems FAQ rubric It can be retrieved using the schema INFORMATION_SCHEMA. INFORMATION_SCHEMA is a system schema and is not displayed by default in the SQL menu of the Management Portal. The method to display it is as follows. Open Management Portal → System Explorer → SQL menu. Check "System" on the left of the schema drop-down. Select INFORMATION_SCHEMA from the schema dropdown. #SQL #Tips & Tricks #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 3 0 0 182
Article Mihoko Iijima · Sep 7 1m read What to do if you get a MAXSTRING error in JSON conversion of dynamic objects InterSystems FAQ rubric You can avoid the error by specifying a stream object as the argument of %ToJSON() used when generating a JSON string from a dynamic object. A code example is below. #JSON #Object Data Model #ObjectScript #Tips & Tricks #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 5 1 0 224
Article Mihoko Iijima · Aug 31 1m read How to rebuild index by ID InterSystems FAQ rubric By specifying the start and end values of the IDs for which you want to rebuild indexes in the arguments of the %BuildIndices() method provided in the persistent class (=table) definition, you can rebuild only the indexes within that range. #Indexing #Object Data Model #Relational Tables #SQL #Tips & Tricks #Caché #InterSystems IRIS #InterSystems IRIS for Health 4 0 0 208
Article Mihoko Iijima · Aug 17 1m read How to get the list of processes programmatically InterSystems FAQ rubric It can be obtained using AllFields query of %SYS.ProcessQuery class. #System Administration #Tips & Tricks #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 4 2 1 171
Article Mihoko Iijima · Jul 20 4m read How to find a specific global variable in the journal file with a command InterSystems FAQ rubric #Globals #System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 4 1 1 238
Article Mihoko Iijima · Jul 13 2m read How to get the size of a global programmatically InterSystems FAQ rubric It can be obtained by using the Size query of the system-provided %SYS.GlobalQuery class. #Globals #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 5 0 2 208
Article Mihoko Iijima · Jun 29 3m read How to compress (maintain) bitmap indexes for volatile tables InterSystems FAQ rubric For volatile tables (tables with many INSERTs and DELETEs), storage for bitmap indexes can become inefficient over time. For example, suppose that there are thousands of data with the following definition, and the operation of bulk deletion with TRUNCATE TABLE after being retained for a certain period of time is repeatedly performed. #Indexing #SQL #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 3 0 0 154
Article Mihoko Iijima · Jun 8 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 194
Article Mihoko Iijima · May 11 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 86
Article Mihoko Iijima · Apr 13 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 338
Article Mihoko Iijima · Apr 7 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 268
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 614
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 439
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 389
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 612
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 297
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 437
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 673