Can anyone explain how the database searching algorithm works in Cache database ?

In Cache WIndows environment:

Trying to use the $SYSTEM.SQL.DDLImport to import XML File that has ClassMethods, no SQL Table, but it doesn't appear to be working. I can use this ClassMethod to create SQL Tables. The manual method I have been using is to go into Cache Management Portal, Classes, Import.

I create an XML file first, then run the following to import but get no errors. Any ideas?

Hello there,

Someone know which impact would have my database changing the locale and its collationTable? I understand it should works fine, without any drawback.

Could someone else confirm my assumption or tell me what could happen? Has anyone changed something like that? (Not to russian, japanese, chinese, etc..)

About queries.. is there any side effect?

Regards

Hi

We have Edge Production where we uploading flat files clinical data, and during testing we do this for several rounds load data, test them and reload them. So everytime we have to generate differnet patient data or change MRNs etc. So request is is there a command to delete patient records that will remove from the tables, and delete reference in the registery as well.

Any guidance that you follow for testing backload data and delete loaded data, pls share

Hi community? Do you have tips for IRIS certification? Resources to study, types of questions more common, anything to help me in my study path. Thanks.

Hello everyone,
First sorry for the ignorance, but, as I am new in the InterSystem world, I came to the following doubt:
Thinking about a database migration. Is it possible, in a non-traumatic way, to take an Oracle database and migrate it completely to Caché?

Hey Intersystems Community,

I have a Problem with the Session Handling in .csp.

I wrote all my Web Services in .csp-Pages and do the work for example in the OnPreHttp Method for to get some data.

After that the Web Service response is in JSON.

I call These Web Services via fetch in my react Single Page application, also Many request parallel. The react App is Rolled out as index.html.
Everything Works Fine with the session Handling via Cookie.

Hi:

I have noticed a problem in some new code I did on one of our productions. I think it is leading to 2 problems.

I have a file, lets call it 1111111111_2300.pdf.

We make the file UNIQUE to avoid an issue. This filename in the working directory gets a session ID Added to it before the .pdf. So lets say it was session ID 9 it would be 1111111111_2300#SID9.pdf in a working directory .

There are further operations to be done on this document before it is sent. For various errors an email is sent back to service users.

Hello, there!

Just a "last call" for anyone who wanted a free certification exam attempt at InterSystems Virtual Summit 2020. Today is the last day that we will accept requests. If you'd like a free attempt and haven't yet requested one, please do it today.

Thanks, and thanks for joining us at Virtual Summit 2020.

Friendly regards,

Jamie Kantor, Certification Manager

Hi Community,

See how IntegratedML in InterSystems IRIS can be used to make machine learning predictions directly from SQL commands:

⏯ IntegratedML in a Nutshell

Good Morning,

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?:

Let's imagine you have to implement a method with a definition

/// Set value to %session.Data
ClassMethod setValue(params...) As %Status
{
}

How it should work

do ..setValue("key1", "val")

is equal to

set %session.Data("key1") = "val"

and

do ..setValue("key1", "key2", "key3", "key4", "val")

is equal to

Hello there,

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.

Is my assumption right?

Regards,

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!!