Article Sylvain Guilbaud · Feb 1 5m read Get a result in JSON from an SQL query Hello Community, SQL language remains the most practical way to retrieve information stored in a database. The JSON format is very often used in data exchange. It is therefore common to seek to obtain data in JSON format from SQL queries. Below you will find simple examples that can help you meet this need using ObjectScript and Python code. #Embedded Python #JSON #ObjectScript #Python #SQL #InterSystems IRIS #InterSystems IRIS for Health 7 1 4 201
Article Sylvain Guilbaud · Jan 8 3m read How to replay certain rows from a SQL source using a SQL adapter (EnsLib.SQL.InboundAdapter) Hello Community, When using an SQL type Business Service, it may happen that we need to replay certain rows from the source table. Let's take as an example the Business Service "from customer SQL" using the generic class EnsLib.SQL.Service.GenericService #Interoperability #SQL #InterSystems IRIS #InterSystems IRIS for Health 4 0 1 211
Article Sylvain Guilbaud · Sep 25, 2023 2m read InterSystems IRIS trainings Hi Community, to learn quickly and in total autonomy on IRIS, I offer you some links which can help you in this beautiful bicycle ride rich in discoveries: #Angular #Beginner #Embedded Python #IRIS Analytics Architect #ObjectScript #Python #InterSystems IRIS #InterSystems IRIS BI (DeepSee) #InterSystems IRIS for Health 7 5 3 333
Article Sylvain Guilbaud · Sep 18, 2023 6m read How to run code at compile time with macros. Hello developers, In this article, I'll show you how to run code at compile time with ObjectScript macros. Here's a use case that recently led me to use this feature: As part of a medical application developed for more than 20 years, we have a large number of parameters. Although we have procedures for documenting these settings, it can be helpful to have a quick view of which settings are actually used by the application code. #Code Snippet #ObjectScript #InterSystems IRIS #InterSystems IRIS for Health 5 0 1 234
Article Sylvain Guilbaud · Aug 24, 2023 1m read How to regenerate a blank AUDIT database? It sometimes happens that due to an adverse event the AUDIT database (IRISAUDIT) has grown to such proportions that the disk it resides on is full and the daily purge cannot be expected to reclaim disk space. #Databases #Security #System Administration #Tips & Tricks #Caché #InterSystems IRIS #InterSystems IRIS for Health 1 4 0 133
Article Sylvain Guilbaud · Apr 20, 2022 4m read Method to recompile classes and routines after a major upgrade During a major version upgrade it is advisable to recompile the classes and routines of all your namespaces (see Major Version Post-Installation Tasks). #Best Practices #System Administration #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 11 3 1 1K
Article Sylvain Guilbaud · Apr 19, 2022 2m read How to manage in a CI/CD pipeline an InterSystems API Manager (IAM aka Kong GATEWAY) configuration ? Kong provides an open source configuration management tool (written in Go), called decK (which stands for declarative Kong) #InterSystems API Manager (IAM) #Tips & Tricks #InterSystems IRIS #InterSystems IRIS for Health #Other 2 0 0 578
Article Sylvain Guilbaud · Oct 19, 2016 7m read How to replace the CACHE.DAT of a mirrored database (i.e: when you need to upgrade a software version) Context: mirrored configuration with one primary member and one async member (without failover/backup member) Purpose: replace the CACHE.DAT of a mirrored database on the primary member. Steps to follow: #Caché #Code Snippet #Databases #System Administration #Mirroring #Tips & Tricks 6 3 0 911
Article Sylvain Guilbaud · Oct 6, 2016 3m read How to dismount/mount a database programmatically to dismount/mount a database, use Dismount() and Mount() methods in SYS.Database class available in %SYS namespace.NB: the database ID is its Directory You'll find some examples of how to dismount/mount and check if a database is mounted (Mounted=1) or not (Mounted=0), and quickly see all the attributes of a database (via zwrite) #Beginner #Code Snippet #Databases #Tips & Tricks #Caché 3 2 1 2.4K
Article Sylvain Guilbaud · Oct 4, 2016 6m read How to add a parameter to a class programmatically This sample class will add parameter DSINTERVAL to each class containing the parameter DSTIME To execute it from a Terminal : #Caché #Code Snippet #Terminal #Tips & Tricks 2 6 1 918
Article Sylvain Guilbaud · Feb 24, 2016 1m read Script sample for running an external Caché / Ensemble backup on Windows (using ##Class(Backup.General).ExternalFreeze() / ExternalThaw()) C:\data\backup.bat :C:\InterSystems\Ensemble\bin\cache -s"C:\InterSystems\Ensemble\Mgr" -U%%SYS ##Class(Backup.General).ExternalFreeze() <C:\data\login.scr echo %ERRORLEVEL%rem note that we need to check errorlevel from highest to lowest here....if errorlevel 5 goto OK #Caché #Code Snippet #System Administration #Backup 2 0 0 1.8K