Question Alicia Watkins · Nov 1, 2021 SQL Method to use in a Mumps routine Hi there, Does anyone have an example of the method used to run an SQL query and generate the view in a Mumps routine. I have several SQL queries created from a vendor that need to be converted and the corresponding view referenced. I cannot seem to find any examples in IDX routines or in the IRIS/Cache documentation. Any help is appreciated. -Alicia #SQL #InterSystems IRIS 0 5 0 491
Question Alicia Watkins · Oct 29, 2021 Set up of SQL Query in the Management Portal in the IRIS Data Platform Hi, Is there way to set up an automated batch job in the Management Portal to execute an SQL query. Also, how can the related view be exported. I have executed the SQL queries and see the view and created files manually. I could not find any related documentation on the batch processes, but I thought batch or automated jobs could be set up via the Management Portal. Any information is appreciated... Thanks #Management Portal #SQL #InterSystems IRIS 0 5 0 269
Question Alicia Watkins · Oct 29, 2021 Filter in Mumps Routine for Excel Spreadsheet File Hi, Is there a way to filter in a routine for a type of filtering column in Excel. I can apply exclusion logic, but wondered if there was some type of method that accomplished a type of filter. Thanks #InterSystems IRIS 0 3 0 286
Question Alicia Watkins · Sep 16, 2021 Cache to IRIS Upgrade for Athena/IDX Hi There, We are upgrading from Cache to IRIS this weekend and I was curious what version of IRIS I need to download. Once our system is live on IRIS, I will no longer be able to use Ensemble. If anyone knows the version of IRIS and could pass that along to me, it would be much appreciated. Thanks #InterSystems IRIS for Health 0 1 0 333
Question Alicia Watkins · Sep 16, 2021 Caché to IRIS Upgrade for Athena / IDX Hi There, We are upgrading from Cache to IRIS this weekend and I was curious what version of IRIS I need to download. Once our system is live on IRIS, I will no longer be able to use Ensemble. If anyone knows the version of IRIS and could pass that along to me, it would be much appreciated. Thanks #InterSystems IRIS for Health 0 2 0 324