Article Hiroshi Sato · Apr 11 2m read How to view the contents of journal files outside of the Management Portal InterSystems FAQ rubric If the journal file is too large to be searched or filtered using the Management Portal, you can refer to it using the following two methods. ① How to use the ^JRNDUMP utility② How to reference it in a program ================================================== ========== #System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 5 0 1 117
Article Hiroshi Sato · Apr 4 1m read Enable access to the Web Gateway/CSP Gateway settings management page from any client InterSystems FAQ rubric The Web/CSP Gateway management page is typically configured so that it cannot be accessed from client machines. To access from any client, do the following: #CSP #System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 3 0 0 140
Article Hiroshi Sato · Mar 28 1m read How to register and reference task schedules programmatically InterSystems FAQ rubric Here, we will introduce a sample code for registering and referencing task schedules. ①Sample of task schedule registration *Create a task to execute do ^TEST every day at 1:00 am. #System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 5 1 0 100
Article Hiroshi Sato · Mar 21 2m read SQL access method for properties that define list collections InterSystems FAQ rubric Properties defined in list collections (Property XXX As list of %String;) can be manipulated using SQL functions: $LISTBUILD(), $LISTFROMSTRING(). For each SQL function, please refer to the document page below. #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 3 1 1 140
Article Hiroshi Sato · Mar 14 1m read What can you do with record maps? InterSystems FAQ rubric Record maps are used to efficiently map files containing delimited records or fixed-width records to message classes used by the interoperability function, and to map files from interoperability function message classes to text files. Record map mapping definitions can be created using the Management Portal, and we also provide a CSV record wizard that allows you to define while reading a CSV file. #Interoperability #Tips & Tricks #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 3 0 1 151
Article Hiroshi Sato · Mar 7 1m read Performing index rebuild in multiple processes while using an application InterSystems FAQ rubric You can use the %IndexBuilder class to perform index rebuilding using multiple processes. Here is an example for the purpose of defining the standard index HomeStateIdx for the Home_State (state information of contact address) column of Sample.Person. The steps are as follows: 1. Hide the index name to be added/rebuilt from the query optimizer. #Tips & Tricks #Caché #InterSystems IRIS #InterSystems IRIS for Health 2 0 1 137
Article Hiroshi Sato · Feb 29 1m read How to register global mapping programmatically InterSystems FAQ rubric Global mappings can be registered using the system class Config.MapGlobals. The method to globally map ^Sample.PersonD in a database SAMPLES other than the default database from the namespace USER is as follows (example executed in a terminal). #System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 1 0 1 111
Article Hiroshi Sato · Feb 15 2m read How to use $ZF(-100) InterSystems FAQ rubric The $ZF(-100) command is used in the following format. $ZF(-100, flags, command name, command arguments) The "/shell" flag is required when running OS commands.For example, use mkdir like this: #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 5 0 3 174
Article Hiroshi Sato · Feb 8 1m read Points to note when uninstalling InterSystems IRIS on Linux InterSystems FAQ rubric On Linux, use the following steps to delete an instance of InterSystems IRIS (hereinafter referred to as IRIS). (1) Stop the IRIS instance you want to uninstall using iris stop # iris stop <instance name> (2) Delete the instance information using the following command #System Administration #InterSystems IRIS #InterSystems IRIS for Health 2 0 1 179
Article Hiroshi Sato · Feb 1 1m read How to enable Interoperability functionality in an existing namespace InterSystems FAQ rubric To enable Interoperability functionality after creating a namespace, use the EnableNamespace method of the %EnsembleMgr class: do ##class(%EnsembleMgr).EnableNamespace() #System Administration #Tips & Tricks #InterSystems IRIS #InterSystems IRIS for Health 3 0 0 98
Article Hiroshi Sato · Jan 18 1m read Settings that need to be copied when migrating the server InterSystems FAQ rubric If you need to migrate your server for some reason, you can reduce the setup work by copying configuration information from the pre-migration environment to the post-migration environment. The following setting information can be migrated. #System Administration #Tips & Tricks #InterSystems IRIS #InterSystems IRIS for Health 5 1 2 174
Article Hiroshi Sato · Jul 6, 2023 1m read How to overload methods in ObjectScript InterSystems FAQ rubric The InterSystems ObjectScript language does not allow you to define methods of the same name with different arguments. It is generally classified as a programming language called a dynamic language. In ObjectScript, you can freely control which arguments are used when executing a method, so unlike languages such as Java, which are not dynamic programming languages, there is no need to strictly distinguish methods by the number of arguments at the compilation stage. #ObjectScript #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 5 0 1 208
Article Hiroshi Sato · Jun 22, 2023 1m read Countermeasures against SQL injection InterSystems FAQ rubric Countermeasures against SQL injection have been published on various websites, but we believe that it is possible to prevent SQL injection in applications using InterSystems SQL as well as other RDBMS by implementing these countermeasures appropriately. In addition, InterSystems Data Platform (hereinafter referred to as IRIS) incorporates several measures that make SQL injection more difficult than general RDBMS. #SQL #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 4 0 0 390
Article Hiroshi Sato · May 25, 2023 2m read API to import/export routines This is an article on the InterSystems FAQ site. 1. Export API a. Use $system.OBJ.Export() to specify individual routines to export. For example: do $system.OBJ.Export("TEST1.mac,TEST2.mac","c:\temp\routines.xml",,.errors) The format to specify is routine name.extension, and the extension is mac, bas, int, inc, obj. Errors during export are stored in errors. #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 7 2 2 377
Article Hiroshi Sato · May 18, 2023 2m read Command line interface and API to create namespaces and databases InterSystems FAQ rubric Using the Config.Configuration class and SYS.Database class methods, you can create and register a namespace database from the terminal. Below is a series of execution examples that create database file /CacheDB/AAA/cache.dat and register database AAA and namespace AAA in the configuration file (cache.cpf).* Execute in the %SYS namespace. * * Make sure that this script runs as the user that is used for all IRIS processes to ensure that the directory has appropriate ownership and permissions * #API #ObjectScript #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 4 3 0 281
Article Hiroshi Sato · Apr 27, 2023 2m read How to migrate data created based on class definition to another system InterSystems FAQ rubric Migrating data to another system takes two steps. 1. Migrating class definitions To migrate the class definition to another system, export it to a file in XML format or UDL format (extension .cls). The export procedure in Studio is as follows. Tools > Export > Select multiple classes you want to migrate with the [Add] button > Check [Export to local file] #System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS 2 4 0 225
Article Hiroshi Sato · Mar 23, 2023 1m read Getting the list of routines programmatically InterSystems FAQ rubric You can programmatically retrieve routine dates and sizes using the RoutineList query of the %Library.Routine (or just %Routine) class. The RoutineList query has an argument, and the routine name to be searched can be specified by prefix match or middle match. (For wildcards, specify * or ?) In the example below, *.MAC is specified as an argument. #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 5 2 0 409
Article Hiroshi Sato · Mar 15, 2023 1m read How to get client IP or machine name InterSystems FAQ rubric When connecting to the database using a client-server architecture, for example using language binding, the machine name of the client can be obtained using the following code: set client=##CLASS(%SYS.ProcessQuery).Open("P"_$j).ClientNodeName #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 3 6 0 644