Search

Clear filter
Question
Mathieu Van Sevenant · Feb 6, 2020

Size Limitation for %ToJSON() with large stream

%ToJSON())set sc=httpRequest.Post("/index/push", 0) Building fileStreamBase64: set fileStream = ##class(%Stream.FileCharacter).
Article
Luis Angel Pérez Ramos · Mar 17

Having trouble connecting your Visual Studio Code to your IRIS instance via WebGateway? Here are some tips!

Indeed, the app is not enabled. To change this, go to its settings by clicking on its name, then select Enabled App. With that activation the problem should be solved.
Question
Francis Galiegue · Apr 13, 2016

Followup on the unconference session about unit test and code coverage: it may be doable after all... But I need help

Timings are indeed irrelevant.The plan is to run unit tests with coverage activated, scan both the test results and monitoring results and collect the results.
Question
Steve Riddle · Nov 9, 2020

Apache RewriteRule on IRIS

csp" ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined LogLevel info <Directory /intersystems/irissys/csp/test> Options Indexes
Question
Nicola Sartore · Nov 5, 2021

Iterate over an SQL result set

%GetData(1) } // Reset cursor index. While (result.%Previous() > 0) { // Do nothing. } // Show get column data again. While (result.%Next()) { Wrtie result.
Announcement
Vadim Aniskin · Feb 27, 2023

InterSystems Ideas News #4

Recently added ideas Dark version of InterSystems Community Add job location for job opportunities section on DC Searchable Index of New Features Set password through environment
Question
Norman W. Freeman · Jan 19, 2023

Why is node ordering different between two environments ?

> Globals > New Global So you set up a global ^TEMP3 with collation German3and run MERGE ^TEMP3=^TEMP and have a new collation.Some time back I set that to have different index
Article
Muhammad Waseem · Jul 6, 2023

ChatGPT with INTERSYSTEMS FHIR SQL BUILDER database

Enabling a data steward to create a customized SQL projection of their FHIR repository, using tables, columns, and indexes, the Builder makes it possible for data analysts to query
Question
Steven Henry Suhendra · Sep 27, 2023

How To Get 1 Data from List in SQL

gt;')For example, if you have a persistent class like this: Class User.SQLtable Extends %Persistent { Property propertyList As list Of %String(MAXLEN = 100) [ Required ]; Index
Question
Jim Cooper · Oct 14, 2024

Using Cache, Python and pypyodbc, struggling dates

= list(row) # copy rows to list for date_col in date_cols: # for each date column index
Question
Andy Stobirski · Apr 21, 2022

Using host variables with embedded SQL isn't working for me

if this is inside a method add [ProcedureBlock = 0] to the method maybe try adding %NOINDEX to your where clauses in case you have an index issue.
Question
Scott Roth · Mar 18, 2022

EnsLib.HL7.Message Querying

I know EnsLib.HL7.Message is a system table, but is there a way we can add additional Indexes to the table to make the query run better/faster without affecting the system?
Question
Paul Mathieson · Oct 26, 2016

Data extraction using SQL Via ODBC

KEY=GSQLOPT_opttablePlay particular attention to the section about using TuneTable to properly set the meta-data around table extent size, selectivity, etc.
Question
Arpitha Ramakrishnaiah · May 11, 2017

Compare and update two directories\namespaces for class files

It contains the class definition of all classes : methods, properties, indexes, storage etc. are all in this global.
Question
Stella Ticker · May 12, 2017

Using multiple processes to process a single file

If this is not indexed or tuned then you will have some serious IO thrashing going on, and no matter how many cores you throw at the problem, you will not get any overall performance