Question Stefan Schick · Jun 12 CREATE TABLE AS SELECT fails when one specific field is present Hello Community, I have encountered the following SQL problem trying to create a table from a SELECT statement. I narrowed the problem down to the following example: 1. The SELECT statement alone works as expected. SELECT m.Name, h.Status FROM EnsLib_HL7.Message m, Ens.MessageHeader h WHERE h.MessageBodyClassName='EnsLib.HL7.Message' AND h.MessageBodyID = m.ID 2. But if "CREATE TABLE ... AS" is added it fails #Databases #SQL #InterSystems IRIS for Health #InterSystems IRIS 0 4 0 79
Question Stefan Schick · Nov 8, 2022 Howto perform tune table in a readonly database (Message Bank) Hello, searching messages in our Message Bank is quite slow, often runs into timeout. I wanted to perform a tune table on Ens_Enterprise_MsgBank.MessageHeader because this apparently has not been done yet - the Tune Table utility shows no entries for selectivity, etc. I tried w $SYSTEM.SQL.Stats.Table.GatherTableStats("""Ens_Enterprise_MsgBank"".MessageHeader") and got this error message #Databases #Enterprise Message Bank #Message Search #SQL #InterSystems IRIS for Health 1 6 1 468
Question Stefan Schick · Jul 20, 2022 Howto disable journaling temporarily for one database Hello everyone, I want to restore a database from an external backup with the journal files. The manual says I should (in short): #Backup #Databases #Journaling #InterSystems IRIS for Health 0 6 0 707
Question Stefan Schick · Mar 24, 2022 Howto add / remove searchtable items Hello, I'd like to add/remove items to/from a custom HL7 searchtable (which extends EnsLib.HL7.SearchTable). Adding new items worked fine by: -add new item to class definition compile class in all namespaces reindexing messages with the BuildIndex() method Question 1: #HL7 #Message Search #InterSystems IRIS for Health 0 3 0 392