Question Oleksandr Kyrylov · Jan 8 MySQL JDBC connection, Linked Table issue Hello, community. I have a problem with running a SQL query on a linked MySQL table. The connection works fine, but the following query throws an error: SELECT TOP 10 * FROM linkedinternal_test.persons [SQLCODE: <-400>:<Fatal error occurred>] #Databases #ObjectScript #SQL #InterSystems IRIS for Health 0 6 1 62
Question Oleksandr Kyrylov · Oct 22, 2024 Is there a way to programmatically import and export table data? Are there any objectscript functions (not wizards) to export and then import table data (including RowID)? It doesn't matter what format the exported file is. The import and export process should preserve all relationships, foreign keys, etc. I need to be able to export and import multiple tables at the same time. I need this to implement the ability to export multiple tables from one instance and load them into another. #InterSystems IRIS #InterSystems IRIS for Health 0 3 0 128
Question Oleksandr Kyrylov · Dec 15, 2022 Installation Manifest I am trying to make application deployable using Installation Manifest. I use IRISHealth_Community-2022.2.0.368.0-win_x64.exe to run manifest during installation I run it from windows command line using the following command: IRISHealth_Community-2022.2.0.368.0-win_x64.exe INSTALLERMANIFEST="C:\FixxerInstall\src\Installer.xml" INSTALLERMANIFESTLOGFILE="Log.txt" INSTALLERMANIFESTLOGLEVEL=3 INSTALLERMANIFESTPARAMS="FlaggerCSPDir=C:\FixxerInstall\src\csp\flagger,ClassImportDir=C:\FixxerInstall\src\import\" It works but a little bit strange. #Deployment #Management Portal #InterSystems IRIS for Health 1 4 0 398
Question Oleksandr Kyrylov · Dec 12, 2022 IRIS Runtime Environment Hello community. I have project on IRIS. I am trying to make application deployable. The Idea is to have 1 file that customer can download and run. For now I realize that whole intersysytems developer kit that includes Studio, terminal acts as runtime environment (Like Java has JDK). Is it possible to wrap my project to 1 archive (Back to Java example .war or .jar) and run it on some application server (like Tomcat) without Studio etc..? Thank you! #Deployment #InterSystems IRIS 0 5 0 295
Question Oleksandr Kyrylov · Apr 5, 2022 Create new Data Transformation Hello communty. I searched a way to transform a HL7 Message to Persistent. I found a way how to create Data Transformation from Mangment Portal -> Data Transformation Interface. But my task is to create somthing similar to that tool in my web site interface. And the question is: Is There way to create something like new instance of Data Transformation class " Ens.DataTransformDTL" using object script? Thank you! #HL7 #ObjectScript #InterSystems IRIS 0 2 0 221
Question Oleksandr Kyrylov · Apr 1, 2022 Find All Property Names in hl7 Message Hello Community! Is in objectscript way to get all properties names from HL7 Message? For example I have HL7 message: #HL7 #ObjectScript #HealthShare 0 2 0 277
Question Oleksandr Kyrylov · Apr 1, 2022 ##class(EnsLib.HL7.Schema).GetFieldNameFromNumber() Bug Hello community! I found a bug or may be I missed something. I want to get field name in "PID" segment by field number in HL7 Message using following object script expession: #HL7 #Interoperability #ObjectScript #InterSystems IRIS for Health 0 4 0 191
Question Oleksandr Kyrylov · Mar 3, 2022 How to run a shell command with admin privileges from InterSystems terminal? Hello dear community I tried to run windows command from an intersystems terminal using objectscript routine. routine : #InterSystems IRIS 0 1 0 394
Question Oleksandr Kyrylov · Feb 2, 2022 ALTER TABLE ALTER COLUMN RENAME Syntax Hi everyone, i cant understand what is wrong in my query: ALTER TABLE MyNamespace.MyTable ALTER COLUMN CurrentColumnName RENAME NewColumnName I just want to rename column name using sql. I could not find any life example using this syntax. SQLCODE for this query is -25: -25 Input encountered after end of query Quote from documentation: #SQL #InterSystems IRIS 0 12 0 699