#Caché

Hi everyone.

I have a function that may end up being called from a number of transformations at the same time, and within the function there's some Embedded SQL to first check if a local table has an entry, and then adds the entry if it doesn't exist.

To prevent a race condition where the function is called by two transformations and they both end up attempting to insert the same value, I'm looking to use the table hint "WITH TABLOCK" on the insert, but this seems to be failing the syntax checks within vscode.

Are table hints supported with embedded sql?

So as asked, I am not talking about KILL - KILL as stated in the docs:

This command removes the variable. If there are no further references to the object, this command also removes the object from memory,

I want to remove the object from memory even if it is still referenced in memory - I understand that cache is not a low-level programming language, But i was hoping there is a way.

Notice that have a RegisteredObject and it is a single reference, It is different than the UnSwizzles suggested in other posts.

Hi,

I am using embeded python to utilize some pythonic library but i got a problem on my hand.

One of the python function i am using return multiple values

in python you would do something like that :

val1, val2, val3, = function(params)

In COS I got something like that :

lib = ##class(%SYS.Python).Import("lib")
val1 = lib.function(params)

And I don't know how to get the second and third values.
Is there a way to get them?

I'm currently making some changes to legacy code and I've noticed that it uses "i $i(" all over the place. Testing in terminal seems like this does the same thing as "do $i()". Is there a difference between these two (and if not is there some interesting history around this)?

Hi everyone.

Is there a sensible approach to having a lookup table in Namespace A, and then accessing this from Namespaces B, C, D (etc)?

I'm trying to avoid creating a Global mapping of the lookup table global (^Ens.LookupTable) as I fear that it would then link all other lookups in that global and lead to some unexpected behaviour, but would be open to trying something in this realm if it's the best option.

Hello,

I am trying to find or locate all Intersystems business components using a particular class. Like I want to find component is using abc.test.cls class.

Hello!

How I can send Synchronous request ?

For example when I cannot call another process until my first business process do not finish.

The goal is to identify programmatically all SOURCE namespaces on a server to which the routines are mapped. In the example below from the Namespaces page in Management Portal the answer would be USER. But some other namespaces on the same server could be mapped to a different namespace or even mapped to itself.

In this paragraph of the article, here is an example of different records to explain how to fill in DirName、Globals and RestAll, but i don't know what is DUA1:[TEST3] ? This doesn't look much like dirname, like this /cachesys/mgr/test/. Can someone explain it? I would greatly appreciate it !

I want to create a datatype that Extends from String and in its set and get it will parse the string or do whatever - my GET works, my SET doesn't.

Does the GetValueAt method of an EnsLib.HL7.message object change the contents of the HL7 message?

We want to do two things, given an incoming HL7 message, in our production:

I have some databases in my cache instance that were created from an online backup file (.cbk). I would like to see the information for these databases in the Databases and SQL sections of Management Portal, but they only appear in the Classes section. I can navigate to the files in my cache instance terminal and see the CACHE.DAT files, and a check in the terminal shows that they are mounted.

This is what I see in the terminal for each database when I check to see if the databases are mounted:

%SYS>set db="/path/for/mydatabase"

Hi,

we need to take backup from alpha to dev environment on daily basis by automatic. Anyone please help?

Hello, I am writing to you because I am receiving a strange error on our Integration server after restoring a Production copy.

On other occasions we had restored the Production copy on this server without problems (in fact it was done weekly)

After restoring the copy when entering the Studio this error appears: