Search

Clear filter
Article
Sergey Kamenev · Nov 11, 2019

Transactions in Global InterSystems IRIS

, to meet the requirement of consistency, you need to include an index change in the same transaction as a global node value change. Say, for example, we have a global ^person
Question
Arpitha Ramakrishnaiah · May 11, 2017

Compare and update two directories\namespaces for class files

classes quick-and-dirty : you can have a look at the global ^oddDEF. 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

to a global will take under 5 minutes.In which case you have a serious bottleneck going on such as a poor referential integrity check. If this is not indexed or tuned then you
Question
Kevin Furze · Sep 13, 2017

is there a reverse version of $listNext

values in the $ListBuild list by skipping that index in the integer-subscripted array): ``` Kill tArray Set tPointer = 0 While $ListNext(tInputList,tPointer,tValue) { If $Data
Question
Goran Stefanovic · Dec 12, 2018

GROUP BY causes NativeError: [10053

by field1This is not the final solution but a way to understand the limits of your server.BTW:an index on field1 might be useful anyhowExampleIndex ff on field1 [ DATA = filed2
Question
Token Ibragimov · Feb 22, 2019

how to convert JSON to object in cache 2010 version

" |%data("expires_in") = 3300 |%data("refresh_token") = "" | %data("scope") = "sms_send" |%data("token_type") = "Bearer" | %index
Question
Paul Mathieson · Oct 26, 2016

Data extraction using SQL Via ODBC

clauses can make the queries perform worse than doing the raw table scan, appreciate adding indexes would help however it's not an option since we don't own the system, we simply
Question
Matthias Ruckenbauer · Aug 29, 2019

linked table (ODBC), %New() -> %Save

and the generated class has an Index MainIndex On id [ IdKey ]; which looks fine to me. The storage is Storage GSQLStorage { <StreamLocation>^remote.SomeDataAccessS
Question
Steve Riddle · Nov 9, 2020

Apache RewriteRule on IRIS

; Options Indexes FollowSymLinks MultiViews AllowOverride All Require all granted RewriteEngine On RewriteRule "^/foo\.csp" "/bar.csp" [PT] <
Question
Nicola Sartore · Nov 5, 2021

Iterate over an SQL result set

cursor index. While (result.%Previous() > 0) { // Do nothing. } // Show get column data again. While (result.%Next()) { Wrtie result.%GetData(1) } Can we not loop
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. When I do that, it returns 0
Question
Michael Davidovich · Mar 21, 2024

OAuth 2.0 Resource Service Scope Check Fail

in a for loop. Further inspection reveals ..ATIndexOpen is an 'Index Open' generated method. So it's trying to open some object with the ATIndex of that encrypted token. Not sure how
Question
Jim Cooper · Oct 14, 2024

Using Cache, Python and pypyodbc, struggling dates

: # for each date column index if row_list[date_col] is not None: # if value is not None
Question
Jeffrey Drumm · Jun 1, 2021

Storing a %DynamicObject

I've been tasked with an interface that needs to supply some additional metadata for the indexing of HL7v2 messages. After toying with a couple of ideas, I thought that it would
Question
Scott Roth · Mar 18, 2022

EnsLib.HL7.Message Querying

statement. 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