Search

in IRIS or Caché. Entity–attribute–value model is usually used for this purpose. I have already written about this at the time: SQL index for array property elements. That's

Python has become the most used programming language in the world (source: https://www.tiobe.com/tiobe-index/) and SQL continues to lead the way as a database language. Wouldn't

is flexibility in a live environment. In the past, if you add an index or ran TuneTable, the SQL in Cached Queries would make use of this new information right away while embedded SQL

to interact with is linked to an underlying Global Definition (Data, Index and Stream) then use the Global Mapping to Map the Globals used by the class into Namespace A 5) The Class

in a columnar index or data map. Also, you'll see it combine columnar and bitmap indices in a number of cases, which is great if you're starting off by adding columnar indices to an existing

= "Pending" ];Index idxRPPI On RPPI;ClassMethod LoadFromFile(){ Set pFileName="C:\mytest.tsv" Set pDelimiter= $C(9) Set rowType="RPPI varchar(50),Name varchar(516),BirthDate Date

is here](https://community.intersystems.com/post/capacity-planning-and-performance-series-index) ***Edited Oct 2016...*** *[Example of script to extract pButtons data to a .csv

://www.tiobe.com/tiobe-index/). [Edit, changed to 8. Pretty sure C and ASM don't have anything like this.]I don't want to say this is you, but some people have no room for innovation

repository to generate synthetic FHIR compatible data shared by @Phillip.Booth E.g. to generate data for 5 patients in an /output subfolder of a current folder call: docker run --rm

patients travel especially for large distance to minimize petrol consumption by cars and planes, and electricity for trains and metro. Non-industry related applications like: Distant

for improvement. That being said, I have enjoyed working with Ensemble and wanted to share the approach I took to poll an external REST API for patient data in the hopes that it might help

dificulty with lists and arrays.For "array of" properties without too many elements I can use JSONARRAYAGG to simply include them inline:"(SELECT JSON_ARRAYAGG(JSON_OBJECT('index

not ? There is no example for IRIS in you github do you plan to do it ? Yes there is if you look (I do need to add an index to the Readme): https://github.com/robtweed/glsdb#the-iriscache-specific

probably are aware, InterSystems IRIS includes comprehensive management and caching for SQL statements. This class groups methods for managing the contents of the Statement Index

://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_flistdata $LISTFIND: return the index of a element in the list - https://docs.intersystems.com/irislatest/csp/docbook