New post

#Caché

45

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

Hi Team,

I have a requirement to delete the Ensemble interfaces , as per User request. I would like to write a routine for that and once I execute, it should remove the interface components through code.
Could you please provide code samples for the following actions ?

  • Deleting an individual rule from a rule class
  • Deleting a class from Ensemble
  • Deleting a Host (Service/Operation/Process) from the Production.

Appreciate the help.

Thanks,

Purushothaman.T

1 6
0 405

At the heart of IRIS and Cache is a very interesting database architecture that we, at M/Gateway Developments, refer to as "Global Storage". If you ever wanted to know more about the fundamentals and capabilities of this underlying database, you might want to read a major analysis we've put together:

https://github.com/robtweed/global_storage

Amongst other things you'll discover that:

8 4
2 587
Question
· May 19, 2021
Error in file handling

When parsing a text file into a mumps routine I get this error

<FUNCT>Method+2^%CDCalBk

Any idea what can be causing this

Thanks in advance

0 2
0 248

Hello everyone,

I have a question, I am trying to use xecute command, but something wrong happen when i was using the command, and i don't know why hahahaha.

I created a file .mac with this code:

label(test) public{
       set routine="variable"
       set call="write routine,!"
       xecute call
       quit
}

But when i run the command, show me this message error:

<UNDEFINED>label+3^tstFJR3 *routine

After that i changed the code to:

0 4
0 246

Hello Community,

we read data from an Oracle database. The desired order is created by an 'order by' in the sql statement. The individual elements of the result set are converted into objects and inserted into a parent object using 'insert' on a property, which implements a one-to-many relationship with the result objects. Later, we iterate over the objects in a for loop and process the contents. At this point the order is apparently no longer identical to the order in which the elements were inserted.

0 5
0 350

I'm looking for a SQL function equivalent for SQL server STRING_SPLIT. I have records like this:

join_to_tx_history (key), ss_note_multi_dict_1_value (varchar)

64559.001 Assistant Principal, Case Worker, Client, Dad, Daughter, Mentor, Mom, Other, Principal, Psychiatrist, School Counselor, Teacher

and I like the field ss_note_multi_dict_1_value split to rows for each comma delimited value. So I can get this:

0 2
0 836
Question
· May 14, 2021
SSLConfig with ECC

Hello everyone,
I can choose between RSA and DSA. ECC seems to be unsupported.
Is there any workarounds without using external binary like curl?

Best regards
RY

0 5
0 414
Question
· May 14, 2021
Luhn Mod N in Cache?

Hi all

I'm trying to recreate this method below in Cache/IRIS.

https://en.wikipedia.org/wiki/Luhn_mod_N_algorithm ISO-7812-1 (LUHN-10)

I've been following the javascript example. It seems simple in theory but i'm struggling with which cache methods to pick.

$LENGTH, $System.SQL.FLOOR() - seem ok

$EXTRACT - I think for .charAt (though may need to correct base)

$FIND - for .indexOf

Any suggestion which would be the best ones for the job?

0 5
0 244
Question
· May 12, 2021
$preprocess failure

There is an undocumented command, $preprocess, that can be called as below. In this case it takes the class name and converts its code into a text array. That includes comments as well. Two questions about it if you know:

0 8
0 258

Hi-

I have a REST client that calls a REST service and as a response gets a stream containing a JSON structure. The service is placing some weird non-printable characters into some places in the JSON document that is throwing off parsing of a down-stream XML document.

What I would like to do is just remove the non-printable characters from the response stream that comes back from my call to the REST service.

Does anyone have a handy utility or method for removing all non-printable characters from a character stream?

1 10
0 2.5K
Question
· May 12, 2021
Cache sql query

Hi ,

I am trying to retrieve the contact type column data of a patient based on the recent date as shown below.

for instance

contacttype Datefrom

contact 1. 24/03/2020

contact 2. 20/05/2021

i need to retrieve the second contact2 based on the recent date.

i tried like below but not working .

Case max(datefrom) >0 then contacttype

End as contacttype

Can anyone please tell me why this is not working.Any other options?

Thanks

jude

0 3
0 317

Hi Team,

A month ago, we purchased the cache license for a 10user limitation. We are a 6developers and using 3different development (internal)servers for this same license. All Developers aren't login at the same time. We have a limitation for login 2developers at a time in a server. But sometimes, we are facing a <LICENSE LIMIT EXCEEDED> issue. We don't know why we are facing this one. So anyone please guide me, why we are getting this type of issue. I have attached the errored screenshot.

0 2
0 862

I need to show the absence of data, so I have to join the list of predefined values with a result of a select statement.
However, it seems like Table Value Constructors in JOIN are either not supported, or I do not understand the syntax.
Basically, I am going for something like this:

Select v.valueId, m.name 
 From (values (1), (2), (3), (4), (5)) v(valueId)
     left Join otherTable m
        on m.id = v.valueId

Is it supported in Cache SQL or not?

0 6
0 186

Hello Community,

We want to send ALL updates from our Cache server to a remote SQL Server instance that will be used as a reporting data warehouse.

Has anyone done this already and if so what is the best way to go about setting this up?

Thanks

Regards

Mike

0 2
0 275

Hi,

I'm getting thousands of errors like the ones below:

2021-05-03 14:11:44 [SQLCODE: <-400>:<Ocorreu um erro fatal>] [Cache Error: <<READ>Dispatch+14^%SYS.BINDSRV>] [Location: <ServerLoop>] [Client info: <Username: KIORAS, Node Name: 3IK0VLS5UU, IP Address: 192.168.1.223, Executable Name: EXTRService.exe, Internal Function: B0>] [%protocol: <52>] $Id: //ce/2018.1.2/kernel/common/src/aclass.c#1 $ 23468 104

0 1
0 598

objects in javascript :

var oM = new Object;

var mMode=["down","up","click"] ;
var key,val ;
for (key in mMode)
{

val = mMode[key] ;
oM[val]={} ;
oM[val].id ="" ;
oM[val].type ="" ;

...

}

so I can access the .type directly as :

oM.down.type

or:

oM["down"].type

what is the syntax in CACHE or IRIS, to achieve such approach via class/key/property...?

acctually: class/object/key/property anlaogue to ^GLOBAL(key,"property")=val

0 9
0 275

Let's say I have a persistent class Sales.
I need to create a report that shows the amount of sales for each branch.
By simply using the class Sales for the source of the cube, I can show what I want with one little exception - the branches that did not have any sales are not shown.
Is there a way around that that does not involve creating a whole new table just for this cube or using a Data connector (they have horrible documentation and I am unable to figure out how to use them properly)?

0 3
0 173