#Caché

Post a job Follow
30 Followers · 4.5K Posts

  

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

Documentation.

Post a job Follow
New
Question Scott Roth · Feb 27

Embedded SQL Help with CURRENT_DATE

I am trying to create a task that has a variable property that a user can specify DaysBack but it keeps coming up blank when I ask the system to get the date as of DaysBack from the CURRENT_DATE. Can someone tell me why I am not getting a value back in my tDate variable?

Class OSU.Workday.TerminationsTask Extends %SYS.Task.Definition
{

Parameter TaskName As STRING = "OSU - Workday Termination Update";

Property DaysBack As %Integer [ InitialExpression = 1 ];

Method OnTask() As %Status
{
	Set tSC=$$$OK
	#Dim tException as %Exception.SystemException
    try{
        set tDate = ""
#Caché #ObjectScript #SQL
4
0 37
New
Question Hour Abdellatif · Feb 26

How to Manage Cache Globals Remotely from a Java Application?

Hello everyone,

I’m trying to find a way to manage globals from our Java application. We have two separate features:

  • Managing tables normally using SQL

  • Managing globals, since some globals exist without class or table definitions

Cache version : Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2016.1.1 (Build 108U_SU), Thu Jul 7 2016 09:39:04 EDT

I tried to retrieve the globals tree, update node values, and append nodes using SQL by calling stored procedures, but I couldn’t find any procedures for adding, updating, or deleting nodes.

I also tried using cacheextreme.jar to access the globals API

#Caché #Java #SQL
0
0 28
New
InterSystems Official Daniel Palevski · Feb 24

Maintenance Releases 2018.1.12 of InterSystems Caché, Ensemble, & HealthShare HealthConnect now available

The 2018.1.12 maintenance releases of InterSystems Caché®, InterSystems Ensemble®, and HealthShare® Health Connect are now Generally Available (GA). 

Please share your feedback through the Ideas Portal using the category Post-Release Feedback so we can build a better product together.

Documentation

You can find the detailed change lists & upgrade checklists on this page:

Early Access Programs (EAPs)

There are many EAPs available now. Check out this page and register to those you are interested.

How to

#Caché #Ensemble #HealthShare #Documentation #Health Connect #InterSystems Official #Platforms #Release
0
0 55
New
Question Carl Deitrich · Feb 17

Data Repoint NULLS Data In New Class Table When Old Class Property Is Changed & Saved

We are attempting to "Repoint" old class data to new class data to save disk space and data redundancy across multiple tables. This works to a point.  In essence the two classes are sharing the same data / Index / stream globals.  But if an ID in the Old_Class is opened, a property is modified, and saved the property that is in the New_Class (but not in the Old_Class) is NULLed / blanked.

Simplified explanation of data and what’s occurring.

Old Class Values   New Class Values
First_Name John   First_Name John
Middle_Initial Q   Middle_Initial Q
Last_Name Public
#Caché #InterSystems IRIS #Globals
10
0 82
Question Jainam Shah · Feb 7

HL7 OUL^R22 processing in Ensemble – DB operation not triggered and conditional OML not sent after ACK

Hello Team,

I am trying to duplicate the production flow in the Ensemble 2018 but after doing all the steps (like copying same class file, adapter file, process class file) as production, still the flow is not working.The error is that it is not reaching the operation (which is supposed to store the data), it gets stuck in the processes.Additionally, I am also trying to add a logic where in OUL message if the value of code 20061 > 30mg, it should automatically send another order back to service (OML).

#Caché #Ensemble #Health Connect #InterSystems IRIS
2
0 51
Question Lynton Blair · Feb 9

IRISSECURESTARTA causes C++ program to terminate with exit code -1073741515..

in C++ program with #include iris-callin.h..  The program terminateswhen it tries to execute IRISSECURESTARTA with exit code -1073741515.

const char *username="user", *password="xyz",*exename="Test_Callin";
int termflag = IRIS_PROGMODE|IRIS_TTNONE|IRIS_TTNEVER;

rc = IRISSECURESTARTA(&pusername, &ppassword, &pexename, termflag, timeout, NULL, NULL);

Note: the %Service_Callin setting is Enabled.

»  
#Caché #InterSystems IRIS
10
0 72