InterSystems IRIS has long supported the obvious translation functions required to for converting to upper or lowercase to enforce case-insensitive string comparison (e.g. in ObjectScript with $zconvert) and sorting (e.g. with SQL collation functions, not to be confused with NLS collation). Customers in international contexts have at times used custom workarounds to also treat accent insensitivity or even more advanced normalization duct tape. We’re looking to address such use cases at the system and SQL level to increase convenience for this international audience, which is well represented on the Developer Community.
I am new to InterSystems Cache and want to explore the database features for one of the use cases we have.
I am trying to find the community version of it from in https://download.InterSystems.com but only found InterSystems IRIS and Intersystems IRIS health community versions.
I have this question for a long time. When I make an insert by SQL from an external application in the fields of type %String, if they are empty, it writes the character $c(0) in the global.
Is there a way so that if an Insert is received in a field of type% String with null value instead of the $ c (0) it leaves it empty?:
We have an immediate requirement for an experienced Intersystems Ensemble/Health Connect consultant to join our team with a good grounding in OO Programming, Healthcare Integration and at least 2 years experience with InterSystems Ensemble/Healthshare Health Connect
I am working with Elastic Container Service in AWS running IRIS for Health containers 2020.1. We have an ECP Data Server. I like to be able to add a new host IP on the data server when a new client starts up. What table are the Allowed ClientIPs stored in?
I have a simple question related to the default locale after healthshare installation.
Will it be the default one already selected in the O.S.?
I mean, because locally I have it in english, but I have seen it in spanish (by default) in some other machines and the only reason I could understand it is because of the O.S. default language.
Pessoal, tenho vagas de trabalho analista de integração / Ensemble (freelance / PJ / CLT) para trabalhar alocado no centro de são paulo. Interessados me enviar um zap (11)967530647.
I have created $zf commands to encrypt/decrypt a file using GNUpg which is working fine in Terminal but not populating output file when I call this from BPL process. Any help would be appreciated!!
Now that Virtual Summit 2020 is over, we'd like to remind everyone that we would still love to hear your input on Certification topics via a very brief survey - less than 8 minutes. You can even indicate if you would like to be a Subject Matter Expert for us in the future and what kinds of incentives you'd like to receive to do so.
Hi Cache team, I am in the need of listing all the user defined schemas that are present my Cache db and also the user defined tables and views and Columns of those tables and views through Queries. So that I can write some JDBC code to run the queries and fetch the above metadata. Any help is appreciated.
See how InterSystems IRIS Adaptive Analytics can be used to aggregate and query billions of records from a virtual cube, applying machine learning and analytics to that data.
https://www.youtube.com/embed/BCV1v91iZwk [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
I have noticed that my backup mirror is warning that the MirrorDatabaseLatencyTime is having a bad time (time in ms is 3000, and warnvalue is 3000). While I look into what may be causing this latency between the two servers, I was considering if reducing the size of the journal files would improve this value in any way.
My assumption is that reducing the file size would mean that the frequency of the journal files being created would be increased, but the reduced size would mean that the transfer and application of each file would be reduced.
https://www.youtube.com/embed/Kklh_ht2aJg [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
IRISReference valueRef = new IRISReference(""); // set inital value to null string
iris.ClassMethodString("%SomeClass","SomeMethod",valueRef);
String myString = valueRef.value; // get the method result
I find the Data Import Wizard very handy. Has anyone thought of enabling the form in the application where it can be adapted for application user requirement?
I currently have an Ensemble production which accepts and handles SOAP requests. I now need to support the exact same data, but instead of coming in as a SOAP request, comes in as a multipart/form-data request. The body of the message would look something like:
I created a Custom Business Service to receive a multipart message with a file and I need to save only the file, not all message. How Can I extract only the file from the pInput to save in a File? This is my code:
InterSystems is proud to offer free InterSystems Certification exam attempts to all attendees of InterSystems Virtual Summit 2020. The one free exam attempt will be made available to all registered attendees and can be used at any time until December 31, 2020.
This is our standard online exam service with online proctoring that is normally priced at $150 per attempt.
Get your hands on our technology with On-Demand Experience Labs available now through November 6th. Each lab is paired with an office hour session scheduled for this week. Learn more about how you can get hands-on with our technology.
Join the office hours to get answers your questions about the labs, talk about how the technology fits into your environment, and discuss implementation. Sign up for the Office Hours/On-Demand Experience Labs today. The labs have gotten great reviews so far!